On 1/15/20 8:19 AM, Kasun Kulathunga wrote:
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.
1) Reading Release Notes for the first release of each version:
This will tell you what changed, most importantly the incompatibilities.
2) Read up on the Ubuntu packages (assuming you are using the PGDG repos):