limitations when using pg_upgrade

Highlighted
Level 2 Adventurer

limitations when using pg_upgrade

Hi,

Does someone know what are the known limitations of using pg_upgrade to upgrade a PostgreSQL server from 9.5 to 10 and higher?

Thanks by advance for sharing your experience.

Kind Regards

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

3 REPLIES 3
Highlighted
EDB Team Member

Re: limitations when using pg_upgrade

Hi @Ludwigh,

 

There are no such limitations of the pg_upgrade. It is the recommended method to perform the major version upgrade.

 

You might face issues related to some extensions such as the PostGIS version mismatch if you are currently using it in the 9.5.

 

You can test the pg_upgrade in the test environment and fix/workaround on those issues if any and then proceed with the production upgrade.

 

NOTE: you will require downtime to perform the pg_upgrade.

 

Refer below link for the more details of pg_upgrade utility: 

https://www.postgresql.org/docs/12/pgupgrade.html

 

Regards,

Sudhir

 

Highlighted
Level 2 Adventurer

Re: limitations when using pg_upgrade

Hi Sudhir,

 

In the meantime, I have found this list:

https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/installation-getting-started/up...

 

Does someome know how to upgrade a server that comtains partitioned (and sub-partitioned tables)?

 

Kind Regards

Tags (1)
Highlighted
EDB Team Member

Re: limitations when using pg_upgrade

Hi,

 

Thank you for the update.

The page that you shared is saying "if you are upgrading from 9.4 or lower version". I think you are upgrading from 9.5 correct? If so, than this limitation is not applicable.

 

--Ankit Shukla

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks