Article ID: 122377, created on Jul 16, 2014, last review on Jul 16, 2014

  • Applies to:
  • Plesk 11.5 for Linux


  1. How to reset password for PostgreSQL user "postgres"?

  2. Authentication to PostgreSQL database not possible, I get the error:

    psql: FATAL: Ident authentication failed for user "username"


Password for PostgreSQL user "postgres" does not correspond password in Psa database.


  1. Try to reset password for PostgreSQL admin user with command:

    # plesk bin database-server --update-server localhost:5432 -type postgresql -passwd 12345

    where 12345 is your new password.

  2. If it fails or authentication still does not work, modify pghba.conf_ file (for PostgreSQL 9.1 server - /etc/postgresql/9.1/main/pg_hba.conf). Add or modify these line as below:

    host all all trust
    host all all ::1/128 trust
  3. Restart PostgreSQL server:

    /etc/init.d/postgresql restart
  4. Login to PostgreSQL server and reset the password:

    #  psql -U postgres -W  -h localhost
    Password for user postgres:
    psql (9.1.13)
    SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
    Type "help" for help.
    postgres=# ALTER USER postgres with password '011juillet2011';
  5. Revert changes in pghba.conf_ back.
  6. Restart PostgreSQL server again and make sure that you can connect to PostgreSQL server.

Search Words

cannot start postgresql in plesk gui (service management)

01bc4c8cf5b7f01f815a7ada004154a2 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF