On Fri, 26 Jan 2024 01:52:58 +0530 Atul Kumar wrote:
>Is the server running locally and accepting connections on that
>socket?
Maybe this will help:
# ss -l | grep 5432
Atul Kumar writes:
> I checked the permissions on /tmp directory and it shows "drwxrwxrwt."
> already, do I need to check something else as well ?
That seems fine, but what about the socket file itself?
regards, tom lane
I checked the permissions on /tmp directory and it shows "drwxrwxrwt."
already, do I need to check something else as well ?
Regards.
On Fri, Jan 26, 2024 at 3:00 AM Tom Lane wrote:
> Ron Johnson writes:
> > On Thu, Jan 25, 2024 at 3:32 PM Adrian Klaver >
> > wrote:
> >> Best guess is you are
Ron Johnson writes:
> On Thu, Jan 25, 2024 at 3:32 PM Adrian Klaver
> wrote:
>> Best guess is you are using a version of psql that is expecting the
>> socket to be somewhere else then where it actually is.
> Is "permission denied" really the error you get when the socket does not
> exist?
nnect.html#LIBPQ-PARAMKEYWORDS
"... is to connect to a Unix-domain socket in |/tmp| (or whatever socket
directory was specified when PostgreSQL was built)"
If you have more then one instance of psql on a machine and they where
built with different defaults you can
end up not hit
On Thu, Jan 25, 2024 at 3:32 PM Adrian Klaver
wrote:
[snip]
> Best guess is you are using a version of psql that is expecting the
> socket to be somewhere else then where it actually is.
>
Is "permission denied" really the error you get when the socket does not
exist?
Trying "psql
On Thu, Jan 25, 2024 at 3:23 PM Atul Kumar 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:
>
On 1/25/24 12:22, Atul Kumar 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
With the
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