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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Sep 27, 2017 at 12:48 PM, Hans Schou <hans.schou@xxxxxxxxx> 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.