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

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(dot)klaver(at)aklaver(dot)com