Re: permission denied on socket - Mailing list pgsql-general

From Ron Johnson
Subject Re: permission denied on socket
Date
Msg-id CANzqJaAcZOrYvGgc52rrJCa4NSoSap6xW6ETetXvOGNFg5_xxg@mail.gmail.com
Whole thread Raw
In response to permission denied on socket  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
On Thu, Jan 25, 2024 at 3:23 PM Atul Kumar <akumar14871@gmail.com> wrote:
Hi,

I have postgres 13 running on centos 7.

I am facing an issue while trying to connect the cluster using the below command.

-bash-4.2$ psql postgres

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: Permission denied

        Is the server running locally and accepting connections on that socket?


but when I am trying to connect using the below command I am able to login to the cluster successfully.

-bash-4.2$ psql postgres -h localhost

postgres=#


I am not sure what is causing this issue and what needs to be done to resolve it ?

 
psql explicitly tells you the problem:
    socket "/tmp/.s.PGSQL.5432" failed: Permission denied
Did you look at the permissions on /tmp/.s.PGSQL.5432?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: permission denied on socket
Next
From: Ron Johnson
Date:
Subject: Re: permission denied on socket