Re: WAL recovery question - 0000001.history - Mailing list pgsql-admin

From Jim Nasby
Subject Re: WAL recovery question - 0000001.history
Date
Msg-id A064867A-413F-4507-870A-0AFDD30F7729@pervasive.com
Whole thread Raw
In response to WAL recovery question - 0000001.history  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
List pgsql-admin
On Apr 28, 2006, at 10:23 AM, Andy Shellam wrote:

> I've developed and am now testing a new "rolling-WAL" script, and have
> noticed something a little peculiar with Postgres 8.1.3.

<snip>

> Note I intend to make this script public once testing has been
> carried out -
> if anyone is interested in testing, please let me know.  The
> "DEBUG" lines
> have been generated by my script, not Postgresql.

Actually, it sounds like the script in pgFoundry will already do what
you want. Search for 'pitr'.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



pgsql-admin by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Backing up large databases
Next
From: andy@andycc.net
Date:
Subject: Re: WAL recovery question - 0000001.history