Обсуждение: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]

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.

Thanks,

Best regards

Jeremy

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?

> 
> Thanks,
> 
> Best regards
> 
> Jeremy
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

On 10/27/21 9:01 AM, Jérémy Garniaux wrote:
> Hi Adrian,
> 
> Thanks for answering on both sides!
> 

>>
>> 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
> 
> 

Your Postgres 13 cluster is up and listening on 5433.

Your choices:

1) Connect using psql -d <some_db> -U <some_user> -p 5433


2) Open:

sudo vi /etc/postgresql/13/main/postgresql.conf

and change

port = 5433

to

port = 5432

and then restart server.


While you are at it:

sudo pg_dropcluster 12 main

to get rid of the orphaned cluster.

-- 
Adrian Klaver
adrian.klaver@aklaver.com

Adrian,

Le 27/10/2021 à 19:30, Adrian Klaver a écrit :
>
> Your Postgres 13 cluster is up and listening on 5433.
>
> Your choices:
>
> 1) Connect using psql -d <some_db> -U <some_user> -p 5433
>
>
> 2) Open:
>
> sudo vi /etc/postgresql/13/main/postgresql.conf
>
> and change
>
> port = 5433
>
> to
>
> port = 5432
>
> and then restart server.
>
>
> While you are at it:
>
> sudo pg_dropcluster 12 main
>
> to get rid of the orphaned cluster.

Great, thanks for your help. Everything is back in order now.

I found out about Pg clusters in the process!

Best regards,

Jeremy

On 10/27/21 12:51, Jérémy Garniaux wrote:
> Adrian,
> 
> Le 27/10/2021 à 19:30, Adrian Klaver a écrit :

>> While you are at it:
>>
>> sudo pg_dropcluster 12 main
>>
>> to get rid of the orphaned cluster.
> 
> Great, thanks for your help. Everything is back in order now.
> 
> I found out about Pg clusters in the process!

Just to be clear the commands I showed are specific to the Debian/Ubuntu 
Postgres packaging.

> 
> Best regards,
> 
> Jeremy
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com