Re: Pgupgrade is best? - Mailing list pgsql-admin

From Fabio Pardi
Subject Re: Pgupgrade is best?
Date
Msg-id 39daa608-a139-bd95-8c6d-25342f8dc2e8@portavita.eu
Whole thread Raw
In response to Pgupgrade is best?  (still Learner <stilllearner23@gmail.com>)
List pgsql-admin
Hi,

If a bit of primary database downtime (and a lot of standby(s) re-sync
time) is an issue, I would use logical replication.

regards,

fabio pardi


On 3/7/19 12:40 PM, 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.
> 
> Thanks in advance.
> 
> Regards.


pgsql-admin by date:

Previous
From: still Learner
Date:
Subject: Pgupgrade is best?
Next
From: Achilleas Mantzios
Date:
Subject: Re: Pgupgrade is best?