How to Import a PostgreSQL database using phpPgAdmin

Updated on March 31, 2022 by John-Paul Briones

0 Minutes, 50 Seconds to Read

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.

John-Paul Briones Content Writer II

John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

4 thoughts on “How to Import a PostgreSQL database using phpPgAdmin”

Arvind Kumar Gupta says:
June 9, 2015 at 6:44 am
Hi,
I am getting the same error “No server supplied!” while importing the database.
However I have configured the php.in as:
```
max_execution_time = 120
max_input_time = 180
memory_limit = 1024M
upload_max_filesize = 128M

Please help.
```
Reply
1. InMotionFan says:
  June 10, 2015 at 2:10 am
  Hello Arvind,
  Do you have an account with us so we may investigate further? There may be something in the file you are trying to import. If you could just provide us your domain name we can attempt to look into this issue further for you.
  Best Regards,
  TJ Edens
  Reply
Paris M says:
May 28, 2015 at 9:33 pm
When I follow these steps, I get an error that says “No server supplied!”

Any advice?
Reply
1. InMotionFan says:
  May 29, 2015 at 6:03 pm
  Hello Paris,
  Thank you for contacting us. I found a similar post, where they suggest you can update your settings in the php.ini.
  Thank you,
  John-Paul
  Reply

How to Import a PostgreSQL database using phpPgAdmin

Importing a Database with phpPgAdmin

4 thoughts on “How to Import a PostgreSQL database using phpPgAdmin”

Was this article helpful? Join the conversation!

Need More Help?