From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Kasun Kulathunga <kask18(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrading from 9.6 to 12 |
Date: | 2020-01-15 16:42:15 |
Message-ID: | 6369381d-2b1a-6660-651b-b74dd25b3658@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-01-15 16:51:34 | Re: Problem with SqlState=23505 when inserting rows |
Previous Message | Werner Kuhnle | 2020-01-15 16:40:47 | Problem with SqlState=23505 when inserting rows |