Hi All,
I can connect to Postgres, but when checking the status of the services, I am getting the following error:
May 23 18:23:13 PG2433 systemd[1]: Starting PostgreSQL Cluster 13-main...
May 23 18:23:21 PG2433 postgresql@13-main[39428]: Warning: connection to the database failed, disabling startup checks:
May 23 18:23:21 PG2433 postgresql@13-main[39428]: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: fe_sendauth: no password supplied
May 23 18:23:21 PG2433 systemd[1]: Started PostgreSQL Cluster 13-main.
When I set the database administrative login by Unix domain socket authentication to md5
or scram-sha-256
, it gives the above error in status, but setting it to trust
is a compliance issue.
Here is the relevant configuration in the pg_hba.conf
file:
# Database administrative login by Unix domain socket
local all all md5
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all scram-sha-256
# IPv4 local connections:
hostssl all all 0.0.0.0/0 scram-sha-256
# IPv6 local connections:
host all all ::1/128 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
And here is the relevant part of the postgresql.conf
file:
listen_addresses = '*'
password_encryption = scram-sha-256
.