From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Pgupgrade is best?
Date: Thu, 7 Mar 2019 14:26:19 +0200
Message-ID: <a271de53-c509-0d7c-1732-b98c84c35f15@matrix.gatewaynet.com> (raw)
In-Reply-To: <CAB3gP9+aJpAkb1vOPreeXiKaphKMKDjz4ioei8JakFfkvH7wpA@mail.gmail.com>
References: <CAB3gP9+aJpAkb1vOPreeXiKaphKMKDjz4ioei8JakFfkvH7wpA@mail.gmail.com>
On 7/3/19 1:40 μ.μ., still Learner wrote:
> Hi There,
>
> Planning to upgrade a double digit TB sized DB from PG 9.4 to 11.1. what is the best way ? Logical or pgupgrade with -k ? Or any other plz suggest. Tried slony but didn't help much in poc.
We upgraded ours from 9.3 -> 10 in summer 2018, with quite a lot of custom code, functions, extensions and it went absolutely fine, we were able to have the server up in some minutes.
However, you should EXTREMELY test everything before the final upgrade, and I dont mean only the actual app (and all kinds of db related code, queries, data sources, drivers, etc), but the actual
pg_upgrade as well. You don't wanna be left compiling and upgrading some extension during the upgrade phase. All should be tested and documented (I wouldn't say automated but you get the point)
beforehand.
>
> Thanks in advance.
>
> Regards.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: Pgupgrade is best?
In-Reply-To: <a271de53-c509-0d7c-1732-b98c84c35f15@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox