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