Re: Postgres Service active with errors
| От | David G. Johnston |
|---|---|
| Тема | Re: Postgres Service active with errors |
| Дата | |
| Msg-id | CAKFQuwbdPDZYw1Gwp2-m_6KokDA1HenOCBJ=47AFO0C6H17r_w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Postgres Service active with errors (nikhil raj <nikhilraj474@gmail.com>) |
| Список | 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
md5orscram-sha-256, it gives the above error in status, but setting it totrustis a compliance issue.
Most people use "peer".
Here is the relevant configuration in the
pg_hba.conffile:# 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 по дате отправления: