Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] - Mailing list pgsql-general

From Jérémy Garniaux
Subject Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
Date
Msg-id 90ebbc17-a029-7340-2272-f37363dd5651@mapper.fr
Whole thread Raw
In response to Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
List pgsql-general
Hi Adrian,

Thanks for answering on both sides!

Le 27/10/2021 à 17:58, Adrian Klaver a écrit :
> On 10/27/21 08:51, Jérémy Garniaux wrote:
>> Hi,
>>
>> After experiencing issues related to the existence of two different 
>> PostgreSQL versions installed on the same machine, I decided to do a 
>> "remove --purge postgresql*" and reinstall postgresql-13. Now the 
>> output of "psql --version" is "psql (PostgreSQL) 13.4 (Ubuntu 
>> 13.4-1)". However, trying to enter psql, I have this error:
>>
>> psql: error: could not connect to server: Aucun fichier ou dossier de 
>> ce type
>>      Is the server running locally and accepting
>>      connections on Unix domain socket 
>> "/var/run/postgresql/.s.PGSQL.5432"?
>>
>> I assume this has been asked many times, but I tried different 
>> solutions proposed on similar posts and none solved my issue.
>
> Same response as to your SO question:
>
> What is the output of pg_lsclusters?
Ver Cluster Port Status                Owner    Data 
directory              Log file
12  main    5432 down,binaries_missing postgres 
/var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
13  main    5433 online                postgres 
/var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
Next
From: "Ryan, Les"
Date:
Subject: WAL File Recovery on Standby Server Stops Before End of WAL Files