pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWarm Standby on 8.4.7
4+ messages / 3 participants
[nested] [flat]
* Warm Standby on 8.4.7
@ 2011-04-13 19:53 Alanoly Andrews <alanolya@invera.com>
2011-04-13 20:04 ` Re: Warm Standby on 8.4.7 Simon Riggs <simon@2ndQuadrant.com>
2011-04-14 11:13 ` Re: Warm Standby on 8.4.7 Jerry Sievers <gsievers19@comcast.net>
0 siblings, 2 replies; 4+ messages in thread
From: Alanoly Andrews @ 2011-04-13 19:53 UTC (permalink / raw)
To: pgsql-admin
Hello,
Is it possible to set up a warm standby pair of postgres instances without using the pg_standby utility? The PG manuals appear to say it is possible. But I don't see the details of how to set this up. How do you keep the standby instance in permanent recovery mode?
Thanks.
Alanoly.
****************************************************
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.
****************************************************
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Warm Standby on 8.4.7
2011-04-13 19:53 Warm Standby on 8.4.7 Alanoly Andrews <alanolya@invera.com>
@ 2011-04-13 20:04 ` Simon Riggs <simon@2ndQuadrant.com>
2011-04-14 14:52 ` Re: Warm Standby on 8.4.7 Simon Riggs <simon@2ndQuadrant.com>
1 sibling, 1 reply; 4+ messages in thread
From: Simon Riggs @ 2011-04-13 20:04 UTC (permalink / raw)
To: Alanoly Andrews <alanolya@invera.com>; +Cc: pgsql-admin
On Wed, Apr 13, 2011 at 8:53 PM, Alanoly Andrews <alanolya@invera.com> wrote:
> Is it possible to set up a warm standby pair of postgres instances without
> using the pg_standby utility? The PG manuals appear to say it is possible.
> But I don’t see the details of how to set this up. How do you keep the
> standby instance in permanent recovery mode?
It is possible. You just need to write a utility very similar to pg_standby.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Warm Standby on 8.4.7
2011-04-13 19:53 Warm Standby on 8.4.7 Alanoly Andrews <alanolya@invera.com>
2011-04-13 20:04 ` Re: Warm Standby on 8.4.7 Simon Riggs <simon@2ndQuadrant.com>
@ 2011-04-14 14:52 ` Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 0 replies; 4+ messages in thread
From: Simon Riggs @ 2011-04-14 14:52 UTC (permalink / raw)
To: Alanoly Andrews <alanolya@invera.com>; +Cc: pgsql-admin
On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews <alanolya@invera.com> wrote:
> Thanks, Simon, for your quick response. I'll try it out with your pg_standby utility. And...if I may ask you one more question on the subject, once the standby is up and running, is there a way to determine whether it is in synch with the primary database (in terms of the last WAL applied)? I guess that the standby cannot be queried as it would be in permanent recovery mode.
At 8.4, no, you cannot query the standby.
9.0 introduces the Hot Standby feature to allow you to query the standby.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Warm Standby on 8.4.7
2011-04-13 19:53 Warm Standby on 8.4.7 Alanoly Andrews <alanolya@invera.com>
@ 2011-04-14 11:13 ` Jerry Sievers <gsievers19@comcast.net>
1 sibling, 0 replies; 4+ messages in thread
From: Jerry Sievers @ 2011-04-14 11:13 UTC (permalink / raw)
To: Alanoly Andrews <alanolya@invera.com>; +Cc: pgsql-admin
Alanoly Andrews <alanolya@invera.com> writes:
> Hello,
>
> Is it possible to set up a warm standby pair of postgres instances
> without using the pg_standby utility? The PG manuals appear to say it
> is possible. But I dont see the details of how to set this up. How
> do you keep the standby instance in permanent recovery mode?
Certainly if you implement the same or possibly extended logic yourself
in whatever language you are comfortable with.
Myself and others have been doing warm-standby since WALs were invented
:-)
When the company I work for started requiring that WS servers be helf
back a configurable time lag from production, I made some minor mods to
our version of the standby script, now written in Python, to make it
happen.
WALs now have to pass sanity and aging checks before being applied.
HTH
--
Jerry Sievers
Postgres DBA/Development Consulting
e: gsievers19@comcast.net
p: 305.321.1144
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-04-14 14:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-13 19:53 Warm Standby on 8.4.7 Alanoly Andrews <alanolya@invera.com>
2011-04-13 20:04 ` Simon Riggs <simon@2ndQuadrant.com>
2011-04-14 14:52 ` Simon Riggs <simon@2ndQuadrant.com>
2011-04-14 11:13 ` 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