Re: WAL recovery - Mailing list pgsql-admin

From Simon Riggs
Subject Re: WAL recovery
Date
Msg-id 1140704662.8759.121.camel@localhost.localdomain
Whole thread Raw
In response to WAL recovery  (Andy Shellam <andy.shellam@mailnetwork.co.uk>)
Responses Re: WAL recovery
List pgsql-admin
On Wed, 2006-02-22 at 16:26 +0000, Andy Shellam wrote:

> Is this scenario possible - that you can keep rolling forward over log
> files as long as necessary, or do you always have to start from a base
> backup?  Nothing is changing on the spare, it's literally a sitting
> duck.

You'll need a restore_command that is a script that sits in a wait loop
when the file it is asked for is not available yet, or other conditions
have occurred such as notification of switchover (manually or
otherwise). When those conditions occur the script should return a
non-zero error condition.

There should be no recovery_target* settings.

Best Regards, Simon Riggs



pgsql-admin by date:

Previous
From: Arnau
Date:
Subject: Re: Delete performance
Next
From: Michael Fuhr
Date:
Subject: Re: large object unlinking