Mark Steben <mark.steben@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxx >> wrote: > > Mark Steben <mark.steben@xxxxxxxxxxxxxxxxx> 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.consulting@xxxxxxxxxxx > 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.consulting@xxxxxxxxxxx p: 312.241.7800
