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