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/>
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. |