On Tue, Aug 14, 2018 at 04:15:12PM -0300, Martín Marqués wrote: > 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)
Well, pglogical has the advantage of reducing the downtime, which may not matter depending on your application and you may be able to accept a it of downtime, and pg_upgrade --link can be pretty quick at its job. Test it before as --link is a no-return trip. -- Michael
signature.asc
Description: PGP signature
