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