public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mark Kirkwood <[email protected]>
To: Simon Riggs <[email protected]>
Cc: Decibel! <[email protected]>
Cc: [email protected]
Subject: Re: pg_standby supported versions
Date: Wed, 26 Nov 2008 22:14:58 +1300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

Simon Riggs wrote:
> On Fri, 2008-08-22 at 00:50 -0500, Decibel! wrote:
>   
>> On Aug 13, 2008, at 4:59 AM, Mark Kirkwood wrote:
>>     
>>> I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml)  
>>> that we have supported version >= 8.2. However it does seem to work  
>>> ok with earlier versions (e.g 8.1) - or am I missing something?
>>>       
>> Hrm, AFAIK it works... Simon?
>>     
>
> It works, yes. But in basic form only.
>
> You'll have problems stopping and starting standby, but the most
> important change is that the process is not restartable. So if you run
> it for a month and then crash, you'll need to re-run the whole month's
> WAL data.
>
>   
Exactly, after posting this I discovered the relevant CVS logs for 
changes to support restartable recovery. It seems to me that perhaps a 
little more detail in the docs would be good here.

At work some folks are using pg_standby with 8.1 and while it does work 
quite well, it took me a wee while to figure out that some of the issues 
they are having are tied up with inability to continue recovery after 
restarting the database or the os!

Best wishes

Mark

view thread (6+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_standby supported versions
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox