Re: Upgrading from 9.6 to 12

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