Обсуждение: Unable to connect Postgres using psql while postgres is alreadyrunning.

Dinesh Chandra 12108 wrote:
> After restarting PostgreSQL Server, I am unable to connect postgres from putty, I am getting error
>  
> psql: could not connect to server: No such file or directory
>     Is the server running locally and accepting
>     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>  
> While postgres is already running and also I am able to connect databases from PGAdmin tool but not from command
prompt.

You know that a local connection only works when you are logged in
on the database machine, right?

Is your database listening on port 5432?

Connect as user "postgres" and run the following queries:

   SHOW port;
   SHOW unix_socket_directories;

That will show the port and the directories where UNIX sockets are created.

You can use a socket directory name with the -h option of psql.

Yours,
Laurenz Albe

Hi Laurenz Albe,

Thanks for your response.

But file   ".s.PGSQL.5432" does not exist .
How can I re-create this or any other option?

Regards,
Dinesh


-----Original Message-----
From: Laurenz Albe [mailto:laurenz.albe@cybertec.at]
Sent: 10 January, 2018 2:41 PM
To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>; pgsql-performance@postgresql.org
Subject: [EXTERNAL]Re: Unable to connect Postgres using psql while postgres is already running.

Dinesh Chandra 12108 wrote:
> After restarting PostgreSQL Server, I am unable to connect postgres
> from putty, I am getting error
>
> psql: could not connect to server: No such file or directory
>     Is the server running locally and accepting
>     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> While postgres is already running and also I am able to connect databases from PGAdmin tool but not from command
prompt.

You know that a local connection only works when you are logged in on the database machine, right?

Is your database listening on port 5432?

Connect as user "postgres" and run the following queries:

   SHOW port;
   SHOW unix_socket_directories;

That will show the port and the directories where UNIX sockets are created.

You can use a socket directory name with the -h option of psql.

Yours,
Laurenz Albe

________________________________

DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged
information.Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended
recipient,please contact the sender by reply email and destroy all copies of the original message. Check all
attachmentsfor viruses before opening them. All views or opinions presented in this e-mail are those of the author and
maynot reflect the opinion of Cyient or those of our affiliates.