Re: Postgres Service active with errors - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Postgres Service active with errors
Date
Msg-id CAKFQuwbdPDZYw1Gwp2-m_6KokDA1HenOCBJ=47AFO0C6H17r_w@mail.gmail.com
Whole thread Raw
In response to Postgres Service active with errors  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-admin


On Thu, May 23, 2024, 16:52 nikhil raj <nikhilraj474@gmail.com> 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.

pgsql-admin by date:

Previous
From: nikhil raj
Date:
Subject: Postgres Service active with errors
Next
From: Ron Johnson
Date:
Subject: Re: Postgres Service active with errors