Re: Postgres Service active with errors

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, May 23, 2024, 16:52 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

You are requiring a password but not configuring psql to send one.  Either change the psql invocation or don't require a password - via peer, not trust.

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.

Most people use "peer".

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

The second one is unused.  And since you want scram it is actually the one you should be using.

You are failing to show any context surrounding the psql connection attempt producing the failure.  You need to track that down and either fix it or show the context when asking for further help.

David J.