From: Simon Riggs <simon@2ndQuadrant.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Another PITR question
Date: Wed, 22 Oct 2008 22:30:24 +0100
Message-ID: <1224711024.27145.505.camel@ebony.2ndQuadrant> (raw)
In-Reply-To: <20081022200919.GE4022@alvh.no-ip.org>
References: <20081022200650.4F5717E424E@mail.int.journyx.com>
<20081022200919.GE4022@alvh.no-ip.org>
On Wed, 2008-10-22 at 17:09 -0300, Alvaro Herrera wrote:
> Scott Whitney wrote:
>
> > However, I want the standby to CONSTANTLY stay in recovery mode, not
> > just restore the WALs it finds when I start it.
> >
> > Is this possible? Can someone explain or point me to some example docs
> > somewhere?
>
> http://www.postgresql.org/docs/8.3/static/pgstandby.html
We should backpatch the docs for 8.2 also. I know we don't usually do
that but it would save some time for people.
Or at least allow comments to be added to previous doc versions.
8.3 docs have the wording
"A working example of a waiting restore_command is provided as a contrib
module named pg_standby. It should be used as a reference on how to
correctly implement the logic described above. It can also be extended
as needed to support specific configurations or environments."
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, alvherre@commandprompt.com, swhitney@journyx.com
Subject: Re: Another PITR question
In-Reply-To: <1224711024.27145.505.camel@ebony.2ndQuadrant>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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