RE: Psql: could not connect to server: No such file or directory

Поиск
Список
Период
Сортировка
От ALEXANDER JOSE
Тема RE: Psql: could not connect to server: No such file or directory
Дата
Msg-id BYAPR15MB2437BB8C4CB747CF676AC374A5340@BYAPR15MB2437.namprd15.prod.outlook.com
обсуждение исходный текст
Ответ на Psql: could not connect to server: No such file or directory  (SAMMY CRISWELL <Sammy_R_Criswell@raytheon.com>)
Список 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@raytheon.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:

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Pierre Ochsenbein
Дата:
Сообщение: Re: Psql: could not connect to server: No such file or directory
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: vacuum of pg_attribute and other infrastructure tables