You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
Sumaneelam09
changed the title
Unable to do postgres version upgrade from 9.6 version to 14
Unable to perform Postgres version upgrade from 9.6 version to 14
Aug 10, 2023
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
The text was updated successfully, but these errors were encountered: