Export PostgreSQL Database Using phpPgAdmin

There are many situations where you may need to export a database, such as creating a backup, cloning the database to another website, or migrating it between servers. Here we cover the steps to export a PostgreSQL database using phpPgAdmin.

Related Articles

Getting Started with cPanel
Export MySQL Database Using phpMyAdmin

Export Database

1. Log into cPanel
2. Navigate to phpPgAdmin, located under the Databases section
   
3. Select the database you wish to export
4. Choose Export in the top menu
5. Choose the format to export the database in
   
   TIP: Structure and data is the recommended selection
6. Under Options, choose either Download or Download compressed with gzip
7. Click the Export button
8. If prompted by your browser to open or save the file, choose Save and select the desired location on your computer or device to save the file