Recommendation for upgrading from PostgreSQL 9.3 - Mailing list pgsql-general

From Karl Martin Skoldebrand
Subject Recommendation for upgrading from PostgreSQL 9.3
Date
Msg-id 3074f1aa5bf34887bb6ee1e6d7014ab4@UKEXCHMBX003.TechMahindra.com
Whole thread Raw
Responses Re: Recommendation for upgrading from PostgreSQL 9.3
RE: Recommendation for upgrading from PostgreSQL 9.3
Re: Recommendation for upgrading from PostgreSQL 9.3
List pgsql-general

Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or 10.x?

I found a few changes at https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10 but are there more things to keep in mind regarding changes in scripts/queries that might affect an already existing application? Should we stop at 9.6 or go 10.x considering that 10.x seems almost about a year old, and 11.x is out there.

I have limited experience with PG so far, but quite long experience with MySQL and OSS in general.

 

Best regards,

 

Martin Skjoldebrand

 

============================================================================================================================

Disclaimer:  This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.

============================================================================================================================

pgsql-general by date:

Previous
From: magodo
Date:
Subject: pg9.6 when is a promoted cluster ready to accept "rewind" request?
Next
From: Pavel Stehule
Date:
Subject: Re: Recommendation for upgrading from PostgreSQL 9.3