Restore Postgresql

mesranet

• August 08, 2016 02:50

Dear All, I have problem with manual restore the Postgresql database, i try to enter psql -f all.sql but the error come out with: psql: FATAL: no pg_hba.conf entry for host "[local]", user "root", database "root", SSL off I follow the advice by cPanel Technical Support by enter at pg_hba.conf with : local all all md5 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" Please advice, what should i do ? TQ so much

• 

  cPanelMichael

  • August 08, 2016 17:53

  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"

  
  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:
  su -l postgres
  Next, ensure you follow the instructions in the document below when attempting to restore a database: PostgreSQL: Documentation: 9.2: pg_restore Thank you.

  0

Please sign in to leave a comment.