pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpatching the OS of a 9.0.4 db with hot standby
3+ messages / 2 participants
[nested] [flat]
* patching the OS of a 9.0.4 db with hot standby
@ 2011-05-19 13:40 Ray Stell <stellr@cns.vt.edu>
2011-06-01 10:47 ` Re: patching the OS of a 9.0.4 db with hot standby Greg Smith <greg@2ndquadrant.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ray Stell @ 2011-05-19 13:40 UTC (permalink / raw)
To: pgsql-admin
I want to do OS patching on prod and hot standby. What is the advised
procedure for maintenance on the two systems? I would think patching
the standby should come first in case it blows something up. Oracle has
a defer switch you can throw on prod to tell it to relax on log shipping
to the standby. Do we have that here?
Sorry if this is in the fine manual.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: patching the OS of a 9.0.4 db with hot standby
2011-05-19 13:40 patching the OS of a 9.0.4 db with hot standby Ray Stell <stellr@cns.vt.edu>
@ 2011-06-01 10:47 ` Greg Smith <greg@2ndquadrant.com>
2011-06-01 13:06 ` Re: patching the OS of a 9.0.4 db with hot standby Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Smith @ 2011-06-01 10:47 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: pgsql-admin
Ray Stell wrote:
> I want to do OS patching on prod and hot standby. What is the advised
> procedure for maintenance on the two systems? I would think patching
> the standby should come first in case it blows something up. Oracle has
> a defer switch you can throw on prod to tell it to relax on log shipping
> to the standby. Do we have that here?
>
Your intuition here is reasonable--test on the standby, if things go
wrong consider reversing the patch, with no impact on the master. It's
not covered in the main because that tends not to cross over into OS
management considerations.
The main parameter you could consider tweaking in this case is
wal_keep_segments, which will let you adjust how long the master queues
things for the standby before it gives up. If you really do lose the
standby, you can run out of disk space on the master eventually if you
haven't set this properly.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: patching the OS of a 9.0.4 db with hot standby
2011-05-19 13:40 patching the OS of a 9.0.4 db with hot standby Ray Stell <stellr@cns.vt.edu>
2011-06-01 10:47 ` Re: patching the OS of a 9.0.4 db with hot standby Greg Smith <greg@2ndquadrant.com>
@ 2011-06-01 13:06 ` Ray Stell <stellr@cns.vt.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Ray Stell @ 2011-06-01 13:06 UTC (permalink / raw)
To: Greg Smith <greg@2ndquadrant.com>; +Cc: pgsql-admin
On Wed, Jun 01, 2011 at 06:47:51AM -0400, Greg Smith wrote:
> Ray Stell wrote:
>> I want to do OS patching on prod and hot standby. What is the advised
>> procedure for maintenance on the two systems? I would think patching
>> the standby should come first in case it blows something up. Oracle has
>> a defer switch you can throw on prod to tell it to relax on log shipping
>> to the standby. Do we have that here?
>>
>
> Your intuition here is reasonable--test on the standby, if things go wrong
> consider reversing the patch, with no impact on the master. It's not
> covered in the main because that tends not to cross over into OS management
> considerations.
>
> The main parameter you could consider tweaking in this case is
> wal_keep_segments, which will let you adjust how long the master queues
> things for the standby before it gives up. If you really do lose the
> standby, you can run out of disk space on the master eventually if you
> haven't set this properly.
>
> --
> Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
> PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
> "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
Thanks for the suggestion. It's great that the keep parm can be
adjusted on the fly.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-06-01 13:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-19 13:40 patching the OS of a 9.0.4 db with hot standby Ray Stell <stellr@cns.vt.edu>
2011-06-01 10:47 ` Greg Smith <greg@2ndquadrant.com>
2011-06-01 13:06 ` Ray Stell <stellr@cns.vt.edu>
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