- Plesk for Linux
How to import PostgreSQL database dump on Plesk for Linux server?
Connect to the server using SSH.
Execute the following command:
# psql example_db < dump_file
# pg_restore -U johndoe -d example_db dump_file
example_dbis the name of the database to which the dump is imported;
johndoe- the database user;
dump_file- the name of the dump file.
Warning: phpPgAdmin is deprecated in Plesk 17.8 and later due to security reasons.
Go to Domains > example.com > Databases and click phpPgAdmin under the name of the required database.
In the phpPgAdmin interface, click on database name > SQL > Browse, select file to upload and click Execute.
Note: Imported backup should contain valid SQL commands.