Staff Member

After that i restart the postgresql and enter the command again psql -f all.sql and now it prompt with the password and when i enter the password, theres another error:

psql: FATAL: password authentication failed for user "root"

Click to expand...

Hello,

First, change your PostgreSQL password via "WHM Home »SQL Services »Configure PostgreSQL" and ensure you use that password when authenticating as the "postgres" user with the following command after logging in via SSH:

Code:

su -l postgres

Next, ensure you follow the instructions in the document below when attempting to restore a database: