Question
How to import PostgreSQL database dump?
Answer
Can be performed in one of the following ways:
Through phpPgAdmin user interface
Warning: phpPgAdmin is deprecated in Plesk 17.8 and later due to security reasons.
-
Open Home > Domains > example.com > Databases and click phpPgAdmin under the name of the required database.
-
In phpPgAdmin interface click on database name > SQL > Browse, select file to upload and click Execute.
Through command line
-
Connect to the server via SSH
-
Execute the following command:
# psql databasename < data_base_dump
Note: Imported backup should contain valid SQL commands.
Additional information
phpPgAdmin is not available for installation in Plesk Onyx 17.8