Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to perform Postgres version upgrade from 9.6 version to 14 #900

Open
Sumaneelam09 opened this issue Aug 10, 2023 · 0 comments
Open

Comments

@Sumaneelam09
Copy link

Sumaneelam09 commented 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

@Sumaneelam09 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant