The source cluster was shut down while in recovery mode. To upgrade, use "rsync" as documented or shut it down as a primary.
Failure, exiting.
postgres@linchpin-db-test01:~/pgroot$
Can anyone help me how to overcome this issue and upgrade postgres version from 9.6 to 14 on both database nodes. Also please let us know if the procedure that we are following is correct and help us with a detailed document for doing this upgrade and links is appreciated.
Hi Spilo Experts,
We have a postgres HA Cluster setup with 2 database node. Briefed the details about the infrastructure in the doc Postgres_cluster_infrastructure.txt
Now we have a requirement to upgrade the postgres database from 9.6 to 14, as the the latest confluence is no longer supporting 9.6 DB Version
Steps involved in achieving this in the below document Spilo_postgres_db_version upgrade notes.docx
We are encountering below mentioned issue
postgres@linchpin-db-test01:~/pgroot$ /usr/lib/postgresql/14/bin/pg_upgrade --old-datadir "/home/postgres/pgroot/pgdata" --new-datadir "/home/postgres/pgroot/pgdata14" --old-bindir "/usr/lib/postgresql/9.6/bin/" --new-bindir "/usr/lib/postgresql/14/bin/" --link Performing Consistency Checks ----------------------------- Checking cluster versions ok
The source cluster was shut down while in recovery mode. To upgrade, use "rsync" as documented or shut it down as a primary. Failure, exiting. postgres@linchpin-db-test01:~/pgroot$
Can anyone help me how to overcome this issue and upgrade postgres version from 9.6 to 14 on both database nodes. Also please let us know if the procedure that we are following is correct and help us with a detailed document for doing this upgrade and links is appreciated.
Thanks & Regards, Sumalatha N