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.klaver@aklaver.com