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.