User “postgres” Has No Password Assigned

September 25, 2019 Jordansphere Linux

Problem

When trying to remotely connect to Postgres 10.10 install for the first time I got and authentication error via pgadmin

From the log files (/var/lib/pgsql/10/data/log/postgresql-Wed.log)

2019-09-25 14:05:38.970 BST [22665] FATAL:  password authentication failed for user "postgres"
2019-09-25 14:05:38.970 BST [22665] DETAIL:  User "postgres" has no password assigned.
        Connection matched pg_hba.conf line 90: "host   all             all             192.168.240.0/24               md5"

 

Resolution

Set a password for postgres

From CentOS CLI

su - postgres

psql

postgres=# \password postgres

 

Powered by WordPress. Designed by elogi.