Re: Postgres Service active with errors

On Thu, May 23, 2024 at 6:52 PM 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*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 socketlocal all all md5
>
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections onlylocal 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.