Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Postgres Service active with errors
Date
Msg-id CANzqJaCT_hze2FghJxnzFptqCn16WWQuHhY4hPqm6q7KgpqdRw@mail.gmail.com
Whole thread Raw
In response to Postgres Service active with errors  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-admin
Tree view
On Thu, May 23, 2024 at 6:52 PM 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
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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Postgres Service active with errors
Next
From: Mukesh Tanuku
Date:
Subject: Postgres/pgpool HA failover process