Postgres Pro
Downloads
Home   >   mailing lists

will this upgrade strategy work? - Mailing list pgsql-admin

From Mark Steben
Subject will this upgrade strategy work?
Date
Msg-id CADyzmyyB2HY8Kzjdb0OVQXkmQSxH4Rb+C+13uupM3k5RwdmOOA@mail.gmail.com
Whole thread Raw
Responses Re: will this upgrade strategy work?
List pgsql-admin
Tree view
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'
  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





pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: User to get locked after three wrong login attempts.
Next
From: Jerry Sievers
Date:
Subject: Re: will this upgrade strategy work?