User “postgres” Has No Password Assigned


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                  md5"



Set a password for postgres

From CentOS CLI

su - postgres


postgres=# \password postgres