Exporting a PostgreSQL database with phpPgAdmin

After installing PostgreSQL and phpPgAdmin on your server, you can begin to work with PostgreSQL databases. In this tutorial, we will show you how to export your PostgreSQL database using phpPgadmin. Exporting your database allows you to save a backup of it, or import it into another account.

How to Export a Database using phpPgAdmin

    1. Login to cPanel.
    2. Click the phpPgAdmin button in the Databases section.
      postgresql export db phppgadmin
       
      Note: The phpPgAdmin button, is only available after installing PostgreSQL on your VPS, or Dedicated server.
    3. On the top left, click the name of the database you want to export. You may have to expand the PostgreSQL option to see the databases.
      postgresql export db select database to
       
    4. Click the Export tab.
      postgresql export db select export tab
       
    5. Choose the format you want to export the database in; I recommend selecting Structure and data.
      postgresql export db select export format
       
    6. In the Options section, choose Download, or Download compressed with gzip, then click the Export button.
      postgresql export db download
       

      You will then be prompted to download the database file. Save it to your computer, and you are finished.

 

 

Congratulations, now you know how to export your PostgreSQL database using phpPgAdmin in cPanel! I the next tutorial we will show you how to import a PostgreSQL database. Learn more about PostgreSQL Hosting options.

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

More Articles by John-Paul

Was this article helpful? Let us know!