Re: pg_upgrade?: Upgrade method from/to any version on random OS?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Hans Schou <hans(dot)schou(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade?: Upgrade method from/to any version on random OS?
Date: 2017-09-27 19:55:03
Message-ID: CAKFQuwbcRn7VL=mvRucWtjGdV3st3HgdfnR4NbA6-bzk2SZB_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 27, 2017 at 12:48 PM, Hans Schou <hans(dot)schou(at)gmail(dot)com> wrote:

> I have looked through
> https://www.postgresql.org/docs/9.6/static/pgupgrade.html
> but it seems more complicated than necessary.
>

​[perform dump/restore]​

It went very good but took 100 minutes - where we had downtime - not so
> good.
>

​There is a correlation between the decreased downtime that pg_upgrade
facilitates and its complexity.​

If you cannot afford the 2 hours of downtime for dump/restore then likely
learning the pg_upgrade process would be the better choice for you.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Polishchuk 2017-09-27 20:08:36 Re: Rsync to a recovering streaming replica?
Previous Message Hans Schou 2017-09-27 19:48:29 pg_upgrade?: Upgrade method from/to any version on random OS?