On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at MyPlesk.com/Plesk360/Platform360 please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

How to import PostgreSQL database dump?

Avatar
Marc López
Updated
Follow
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.

  1. Log into Plesk

  2. Open Home > Domains > example.com > Databases and click phpPgAdmin under the name of the required database.

  3. In phpPgAdmin interface click on database name > SQL > Browse, select file to upload and click Execute.

Through command line

  1. Connect to the server via SSH

  2. 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.

Have more questions? Submit a request

Related articles