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?
From: Laurenz Albe [mailto:laurenz.a...@cybertec.at]
Sent: 10 January, 2018 2:41 PM
To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com>;
Subject: [EXTERNAL]Re: Unable to connect Postgres using psql while postgres is
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:
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.
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 attachments for viruses before opening them.
All views or opinions presented in this e-mail are those of the author and may
not reflect the opinion of Cyient or those of our affiliates.