Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] pg_upgrade?: Upgrade method from/to any version onrandom OS? - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] pg_upgrade?: Upgrade method from/to any version onrandom OS?
Date
Msg-id CAKFQuwbcRn7VL=mvRucWtjGdV3st3HgdfnR4NbA6-bzk2SZB_g@mail.gmail.com
Whole thread Raw
In response to [GENERAL] pg_upgrade?: Upgrade method from/to any version on random OS?  (Hans Schou <hans.schou@gmail.com>)
List pgsql-general
Tree view
On Wed, Sep 27, 2017 at 12:48 PM, Hans Schou <hans.schou@gmail.com> wrote:
I have looked through 
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.

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: [GENERAL] pg_upgrade?: Upgrade method from/to any version on random OS?
Next
From: Igor Polishchuk
Date:
Subject: Re: [GENERAL] Rsync to a recovering streaming replica?