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