Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]

From: Jérémy Garniaux <jeremy(at)mapper(dot)fr>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
Date: 2021-10-27 16:01:52
Message-ID: 90ebbc17-a029-7340-2272-f37363dd5651@mapper.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ryan, Les 2021-10-27 16:42:52 WAL File Recovery on Standby Server Stops Before End of WAL Files
Previous Message Adrian Klaver 2021-10-27 15:58:06 Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]