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.
You must create a PostgreSQL database before you can complete this guide.
Importing a Database with phpPgAdmin
- Login to cPanel.
- Click the phpPgAdmin button in the Databases section.
Note: The phpPgAdmin button, is only available after installing PostGreSQL on your VPS, or Dedicated server. - On the top left, click the database you want to import the backup into.
- Click the SQL tab.
- Click the Browse button, and select your database backup file, and click Open.
- 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.