Re: Postgres Service active with errors

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, May 23, 2024 at 6:52 PM nikhil raj <nikhilraj474@xxxxxxxxx> wrote:

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

local/sockets authentication is, by default, peer authentication.  PG knows the user is authenticated because Linux has already authenticated the account.