How to import PostgreSQL database dump?
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.