Re: upgrading from pg 9.3 to 10

El 14/08/18 a las 14:44, Edmundo Robles escribió:
> Is safe  to upgrade from pg 9.3 to pg 10 directly using pg_upgrade or
> is better upgrade, with pg_upgrade,  from  9.3 -> 9.4 ->9.5 -> 9.6 -> 10.

That is quiet a jump. But not imposible with pg_upgrade.

I'd recommend testing with a clone of the server to verify that it works
properly (not only pg_upgrade, but your application with the new version
of postgres). Also to time the window you'll need and see if there are
things to be aware of, like extensions which are upgraded and might
break the upgrade.

Now if you are going to first jump to 9.4, I'd recommend using pglogical
after getting to 9.4 and upgrade straight from 9.4 to 10 (always after
testing your application against 10)

Regards,

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services