Обсуждение: will this upgrade strategy work?
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
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
Mark Steben <mark.steben@drivedominion.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.consulting@comcast.net p: 312.241.7800
HI Jerry
Thanks for your response. Is the copy option of pg_upgrade faster than a traditional pg_dump-restore?
Remember we are striving for speed and mimimal downtime.
On Wed, Sep 5, 2018 at 3:20 PM, Jerry Sievers <gsievers19@comcast.net> wrote:
Mark Steben <mark.steben@drivedominion.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.consulting@comcast.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
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
Mark Steben <mark.steben@drivedominion.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@comcast.net >> wrote: > > Mark Steben <mark.steben@drivedominion.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.consulting@comcast.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.consulting@comcast.net p: 312.241.7800