Re: Pgupgrade is best?

From: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Pgupgrade is best?
Date: 2019-03-07 12:05:12
Message-ID: 39daa608-a139-bd95-8c6d-25342f8dc2e8@portavita.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2019-03-07 12:26:19 Re: Pgupgrade is best?
Previous Message still Learner 2019-03-07 11:40:01 Pgupgrade is best?