From: | ALEXANDER JOSE <aangelj(at)hotmail(dot)com> |
---|---|
To: | SAMMY CRISWELL <Sammy_R_Criswell(at)raytheon(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: Psql: could not connect to server: No such file or directory |
Date: | 2019-05-02 16:08:23 |
Message-ID: | BYAPR15MB2437BB8C4CB747CF676AC374A5340@BYAPR15MB2437.namprd15.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi, Check if in the environment variables you have defined the route
export PGPORT = 5432
export PGHOST = / var / run / postgresql / .s.PGSQL.5432.
Let me know if you can solve it.
Alexander Angel
DBA Postgresql
________________________________
De: SAMMY CRISWELL <Sammy_R_Criswell(at)raytheon(dot)com>
Enviado: jueves, 2 de mayo de 2019 3:50 p.m.
Para: pgsql-admin
Asunto: Psql: could not connect to server: No such file or directory
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:
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2019-05-02 16:10:33 | Re: vacuum of pg_attribute and other infrastructure tables |
Previous Message | Pierre Ochsenbein | 2019-05-02 16:04:16 | Re: Psql: could not connect to server: No such file or directory |