Postgres Pro
Downloads
Home   >   mailing lists

Re: Psql: could not connect to server: No such file or directory - Mailing list pgsql-admin

From rammohan ganapavarapu
Subject Re: Psql: could not connect to server: No such file or directory
Date
Msg-id CALm_VjiSw=QMZhANAbfGc+chCtu8kB+LTZsE3C7Ki-xLuY9z_g@mail.gmail.com
Whole thread Raw
In response to Psql: could not connect to server: No such file or directory  (SAMMY CRISWELL <Sammy_R_Criswell@raytheon.com>)
Responses Re: Psql: could not connect to server: No such file or directory  (Pierre Ochsenbein <pierreochsenbein@gmail.com>)
List pgsql-admin
Tree view
Are you using -h localhost to connect? you can do lsof -p {pg pid} to see where is Unix socket directory pointing to, also check postgresql.conf file to check if Unix socket location is non default value.

On Thu, May 2, 2019, 8:50 AM SAMMY CRISWELL <Sammy_R_Criswell@raytheon.com> wrote:

Good morning,

 

I am preparing to upgrade my pqsl server from 9.3.5 to 9.6.12. I have installed the 9.6 rpm onto the server that has 9.3.5 running. Postgres is still running 9.3.5 on that server, but when I try to run psql I get the following message.

 

“psql: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?”

The database is still running and working I just can’t use any of the client commands like psql, pg_dump….

And there is no "/var/run/postgresql/.s.PGSQL.5432" file.

 

Can someone help with this problem.

 

Sam Criswell | Senior Systems Engineer I

Infrastructure Engineering
Intelligence, Information and Services (IIS)

CityLine Phone: +1 972.664.8870
Raytheon Company
1737 East Cityline Drive | Richardson, TX 75082 USA

 

Upcoming PTO:

 

pgsql-admin by date:

Previous
From: SAMMY CRISWELL
Date:
Subject: Psql: could not connect to server: No such file or directory
Next
From: Pierre Ochsenbein
Date:
Subject: Re: Psql: could not connect to server: No such file or directory