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.

You must create a PostgreSQL database before you can complete this guide.

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.

JB
John-Paul Briones

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

More Articles by John-Paul

Thoughts on “How to Import a PostgreSQL database using phpPgAdmin

  • 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.

     

     

     

    • 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

Was this article helpful? Let us know!