Re: Test mail for pgsql-admin - Mailing list pgsql-admin

From Andrew Wang
Subject Re: Test mail for pgsql-admin
Date
Msg-id CAB7XbVdpEKmpYr=NeAsCEHudZ+un4SUR5sQSf57ReRvu-pKyRQ@mail.gmail.com
Whole thread Raw
In response to Re: Test mail for pgsql-admin  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Test mail for pgsql-admin
List pgsql-admin
Thanks, now 3 versions, 14, 15, and 16 are running as shown below.  I did pg_upgrade as detailed below, but it asked me to shutdown postmaster, should which postmaster be down and how?

##three
#sudo pg_lsclusters
 Ver Cluster Port Status Owner    Data directory              Log file
14  main    5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
15  main    5434 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
16  main    5433 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log

##pg_upgrade
/usr/lib/postgresql/16/bin/pg_upgrade -b /usr/lib/postgresql/15/bin -B /usr/lib/postgresql/16/bin -d /var/lib/postgresql/15/main -D /var/lib/postgresql/16/main --check
There seems to be a postmaster servicing the new cluster.
Please shutdown that postmaster and try again.
Failure, exiting

On Thu, Jan 11, 2024 at 3:45 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

On Thu, Jan 11, 2024 at 4:12 PM Andrew Wang <andrew.wang.2009@gmail.com> wrote:

I tried to install the 15 and 16, but the configuration complained ports and other things. 

All of which are issues that simple Postgresql configuration changes can solve.


--
Best,

Andrew Wang

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Test mail for pgsql-admin
Next
From: Scott Ribe
Date:
Subject: Re: Test mail for pgsql-admin