Thread: PostgreSQL upgrade from 9.4.2 to 9.6.12
Hi Everyone,
We have a legacy application running on Ruby on Rails on AWS infrastructure. We wanted to do a DB upgrade from PostgreSQL version 9.4.2 to 9.6.12.
We tried finding out any breaking changes from 9.4.x to 9.6.x upgrade but could not find out by reading the documentation.
Please let us know if the PostgreSQL version 9.6.12 is backwards compatible with version 9.4.2 or if there are breaking changes do let us know.
Thank you.
Regards,
Ashwini
On 7/4/19 7:48 AM, Ashwini Singh wrote: > Hi Everyone, > > We have a legacy application running on Ruby on Rails on AWS > infrastructure. We wanted to do a DB upgrade from PostgreSQL version > 9.4.2 to 9.6.12. > > We tried finding out any breaking changes from 9.4.x to 9.6.x upgrade > but could not find out by reading the documentation. > > Please let us know if the PostgreSQL version 9.6.12 is backwards > compatible with version 9.4.2 or if there are breaking changes do let us > know. Breaking changes rather depends on what you are doing in your app. Postgres will have backwards incompatible changes between major releases. Prior to Postgres version 10 that that was any version that changed the X in X.X.y in the versioning. For 10+ that is X.y. To see what backwards incompatible changes occurred go to the Release Notes for the first new major version(change in X). So for you migration path : https://www.postgresql.org/docs/9.5/release-9-5.html https://www.postgresql.org/docs/9.6/release-9-6.html The big(incompatible) changes will be listed under: Migration to Version <some_version> Changes are cumulative . > > Thank you. > > Regards, > Ashwini -- Adrian Klaver adrian.klaver@aklaver.com
If you're doing this in RDS make sure to check what extensions each of your databases in your RDS instance has (we use PostGIS and hstore for example) and upgrade them incrementally. AWS provide the right libs installed to do those updates between each engine version, but not necessarily between engine versions more than 1 major version apart.
You can see which versions of the extensions are installed in RDS in each engine version on this page: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions
This may also be of interest to you, but checking official docs as Adrian recommended is best.