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
- Log into cPanel
- Navigate to phpPgAdmin, located under the Databases section
- Select the database you wish to export
- Choose Export in the top menu
- Choose the format to export the database in
TIP: Structure and data is the recommended selection - Under Options, choose either Download or Download compressed with gzip
- Click the Export button
- 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