Re: Recommendation for upgrading from PostgreSQL 9.3

On 11/12/18 1:17 AM, Karl Martin Skoldebrand wrote:
> 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.

Go here:

https://www.postgresql.org/docs/10/release.html

and click on the notes for the first release for each major release. 
Prior to 10 the numbering system was Major.major.minor, e.g. 9.3.x --> 
9.4.x was a major change. With 10+ the scheme is Major.minor so 10.x --> 
11.x. So in your case the first release you would visit is:

https://www.postgresql.org/docs/10/release-9-4.html

To be more certain I would set up a dev database with the new version 
and test against that.


> 
> 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.
> 
>
============================================================================================================================
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com