Re: Postgres Service active with errors

On Thu, May 23, 2024, 16:52 nikhil raj <nikhilraj474(at)gmail(dot)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(at)13-main[39428]: Warning: connection to the database failed, disabling startup checks:
> May 23 18:23:21 PG2433 postgresql(at)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 socketlocal all all md5
>
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections onlylocal 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.