will this upgrade strategy work?

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: will this upgrade strategy work?
Date: 2018-09-05 19:12:41
Message-ID: CADyzmyyB2HY8Kzjdb0OVQXkmQSxH4Rb+C+13uupM3k5RwdmOOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2018-09-05 19:20:02 Re: will this upgrade strategy work?
Previous Message Stephen Frost 2018-09-05 17:48:32 Re: User to get locked after three wrong login attempts.