MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
MSSQL databases take long time to load on Plesk server
Cannot add PostgreSQL with custom port in Plesk: Is the server running locally and accepting connections on Unix domain socket
MySQL instance is stopped and set as Manual Startup during Updates
Unable to create Mysql database in Plesk: Database user name is invalid. Only latin letters are allowed in the database user name
How to increase upload dump size in phpMyAdmin?
How to allow/deny customers to choose a database server when creating a database in Plesk
Error when running a query inside PHPMyAdmin in Plesk for Windows Server: unrecognized statement type (near lock)
Unable to rename table in phpMyAdmin under Domain: Cannot read property 'substring' of undefined
Websites show garbled characters after Plesk update

See more

How to import PostgreSQL database dump?

Updated February 26, 2019 14:57

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

Log into Plesk
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.

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request