pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwill this upgrade strategy work?
4+ messages / 2 participants
[nested] [flat]
* will this upgrade strategy work?
@ 2018-09-05 19:12 Mark Steben <mark.steben@drivedominion.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mark Steben @ 2018-09-05 19:12 UTC (permalink / raw)
To: 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;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: will this upgrade strategy work?
@ 2018-09-05 19:20 Jerry Sievers <gsievers19@comcast.net>
parent: Mark Steben <mark.steben@drivedominion.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jerry Sievers @ 2018-09-05 19:20 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: will this upgrade strategy work?
@ 2018-09-05 19:28 Mark Steben <mark.steben@drivedominion.com>
parent: Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Mark Steben @ 2018-09-05 19:28 UTC (permalink / raw)
To: Jerry Sievers <gsievers19@comcast.net>; +Cc: pgsql-admin
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 <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;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: will this upgrade strategy work?
@ 2018-09-05 21:01 Jerry Sievers <gsievers19@comcast.net>
parent: Mark Steben <mark.steben@drivedominion.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jerry Sievers @ 2018-09-05 21:01 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; +Cc: Jerry Sievers <gsievers19@comcast.net>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-09-05 21:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-05 19:12 will this upgrade strategy work? Mark Steben <mark.steben@drivedominion.com>
2018-09-05 19:20 ` Jerry Sievers <gsievers19@comcast.net>
2018-09-05 19:28 ` Mark Steben <mark.steben@drivedominion.com>
2018-09-05 21:01 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox