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

Hi Rammohan

Please check the error in postgresql log file.

Le jeu. 2 mai 2019 à 18:01, rammohan ganapavarapu <rammohanganap(at)gmail(dot)com>
a écrit :

> 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(at)raytheon(dot)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: *
>>
>>
>>
>

--
Cordialement,

*Pierre Ochsenbein*
Mobile: +33668295394
pierreochsenbein(at)gmail(dot)com