Thread: Upgrading from 9.6 to 12
Hello,
We're currently in the beginning phases of a project to upgrade our Postgres cluster from 9.6 to a newer version (most likely v12).
This is actually going to be a two part move since we're going to move from a RHEL-backed cluster to an Ubuntu server-backed one.
I was wondering if there are any potential pitfalls we should look out for, particularly considering we're jumping up 4 major version and tossing in an OS change for good measure.
Best Regards,
Kasun Kulathunga
On 1/15/20 8:19 AM, Kasun Kulathunga wrote: > Hello, > > We're currently in the beginning phases of a project to upgrade our > Postgres cluster from 9.6 to a newer version (most likely v12). > > This is actually going to be a two part move since we're going to move > from a RHEL-backed cluster to an Ubuntu server-backed one. > > I was wondering if there are any potential pitfalls we should look out > for, particularly considering we're jumping up 4 major version and > tossing in an OS change for good measure. Start by: 1) Reading Release Notes for the first release of each version: https://www.postgresql.org/docs/10/release-10.html https://www.postgresql.org/docs/11/release-11.html https://www.postgresql.org/docs/12/release-12.html This will tell you what changed, most importantly the incompatibilities. 2) Read up on the Ubuntu packages (assuming you are using the PGDG repos): https://www.postgresql.org/download/linux/ubuntu/ https://wiki.postgresql.org/wiki/Apt > > Best Regards, > Kasun Kulathunga -- Adrian Klaver adrian.klaver@aklaver.com