How to Import a PostgreSQL database using phpPgAdmin

Now that you’ve installed PostgreSQL and phpPgAdmin on your server, you can begin to create and manage databases. In this tutorial, we’ll show you how to import a PostgreSQL database using phpPgAdmin in cPanel.

Importing a Database with phpPgAdmin

1. Login to cPanel.
2. Click the phpPgAdmin button in the Databases section.
   
   Note: The phpPgAdmin button, is only available after installing PostGreSQL on your VPS, or Dedicated server.
3. On the top left, click the database you want to import the backup into.
   
4. Click the SQL tab.
   
5. Click the Browse button, and select your database backup file, and click Open.
   
6. Click the Execute button to begin the import process. This will take some time depending on the size of the database. When you see a SQL Executed message, you are finished. You will also see that your tables are now populated.
   

Congratulations, now you know how to import a PostgreSQL database using phpPgAdmin! Learn more about PostgreSQL Hosting options.