Re: upgrading from pg 9.3 to 10

2018-08-22 Thread bricklen
Hi Stephen, thanks for the feedback, it is much appreciated! On Mon, Aug 20, 2018 at 12:15 PM Stephen Frost wrote: > * bricklen (brick...@gmail.com) wrote: > > Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one > > jump. We did this in production earlier this year for 1500 P

Re: upgrading from pg 9.3 to 10

2018-08-20 Thread Stephen Frost
Greetings, * bricklen (brick...@gmail.com) wrote: > On Tue, Aug 14, 2018 at 10:45 AM Edmundo Robles > wrote: > > 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. > > Using pg_upgrade, it is definit

Re: upgrading from pg 9.3 to 10

2018-08-20 Thread bricklen
Hi Edmundo, On Tue, Aug 14, 2018 at 10:45 AM Edmundo Robles wrote: > 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. > Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one jump.

Re: upgrading from pg 9.3 to 10

2018-08-15 Thread Michael Paquier
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

Re: upgrading from pg 9.3 to 10

2018-08-14 Thread Martín Marqués
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

upgrading from pg 9.3 to 10

2018-08-14 Thread Edmundo Robles
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. --