Subject: Re: Another PITR question
From: Simon Riggs <simon@2ndQuadrant.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Scott Whitney <swhitney@journyx.com>, pgsql-admin@postgresql.org
In-Reply-To: <20081022200919.GE4022@alvh.no-ip.org>
References: <20081022200650.4F5717E424E@mail.int.journyx.com>
	<20081022200919.GE4022@alvh.no-ip.org>
Content-Type: text/plain
Date: Wed, 22 Oct 2008 22:30:24 +0100
Message-Id: <1224711024.27145.505.camel@ebony.2ndQuadrant>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit


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