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

Поиск
Список
Период
Сортировка
От Jérémy Garniaux
Тема Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
Дата
Msg-id 90ebbc17-a029-7340-2272-f37363dd5651@mapper.fr
обсуждение исходный текст
Ответ на Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
Следующее
От: "Ryan, Les"
Дата:
Сообщение: WAL File Recovery on Standby Server Stops Before End of WAL Files