Re: will this upgrade strategy work?

Mark Steben <mark(dot)steben(at)drivedominion(dot)com> writes:

> HI Jerry
>
> Thanks for your response.  Is the copy option of pg_upgrade faster
> than a traditional pg_dump-restore?

It should be unless the system is horribly bloated. But your proposal
doesn't specify dump/restore anyway.

> Remember we are striving for speed and mimimal downtime.

Then consider doing a logical live replica using any of slony, skytools
or pglogical from your 9.4 system into 9.6 and then just promote the 9.6
system and run on it.

FYI

>
> On Wed, Sep 5, 2018 at 3:20 PM, Jerry Sievers <gsievers19(at)comcast(dot)net
>> wrote:
>
> Mark Steben <mark(dot)steben(at)drivedominion(dot)com> writes:
>
> > Good afternoon, team.
> >
> > We wish to do a postgres upgrade from 9.4 to 9.6.  In order to
> > minimize downtime we were thinking to do this:
> >   1. bring postgres down (9.4 is on 'diskset 1')
> >   2. do a physical copy of the data to 'diskset 2' (same
> phyxical
> > server.
> >   3.  do an inplace pg_upgrade  to 9.6 on 'diskset 2'
>
> Note that the copy (vs link) option of pg_upgrade is
> non-destructive and
> probably a simpler version than what you're proposing.
>
> Whatever method you choose, best do a prior test run in a
> non-prod
> setting to insure everything is correct.
>
> HTH
>
>
> >   4.  Bring postgres up on 9.6 diskset 2
> >  This way we have 9.4 on diskset 1 to fall back on.
> >
> > This would work much faster than the traditional dump restore.
> >
> > Any comments welcome.  Thanks.
> >
> >
> > --
> > Mark Steben
> >  Database Administrator
> > @utoRevenue | Autobase 
> >   CRM division of Dominion Dealer Solutions 
> > 95D Ashley Ave.
> > West Springfield, MA 01089
> > t: 413.327-3045
> > f: 413.383-9567
> >
> > www.fb.com/DominionDealerSolutions
> > www.twitter.com/DominionDealer
> >  www.drivedominion.com
> >
> > 
> >
> >
> >
> >
> >
> >
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres(dot)consulting(at)comcast(dot)net
> p: 312.241.7800
>
>
>
>
> --
> Mark Steben
>  Database Administrator
> @utoRevenue | Autobase 
>   CRM division of Dominion Dealer Solutions 
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
>  www.drivedominion.com
>
>
>
>
>
>
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800