Plesk for Linux
kb: how-to
ABT: Group B
Applicable to:
- Plesk for Linux
Question
How to import PostgreSQL database dump?
Answer
Can be performed in one of the following ways:
Click on a section to expand
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
Comments
0 comments
Please sign in to leave a comment.