Re: PITR Questions

On Aug 9, 2006, at 10:31 PM, Matthew T. O'Connor wrote:
> Jim C. Nasby wrote:
>> Take a look at http://pgfoundry.org/projects/pgpitrha/
>
> I had already seen this however it says that this project has yet
> to release any files, so I thought it was a dead project.  Am I
> missing something?

No, the project hasn't released files (yet), but they are available
in CVS. I'll try to at least get a tarball up in the next week.

>> Also, note that in 8.1, you have to manually archive the last WAL
>> file
>> after pg_stop_backup(), or you backup is useless until that WAL file
>> fills up on its own and is archived.
>
> Right, I was hoping to find someone who had well written and tested
> bash script or something that did this.

I think the project does that, but I can't swear to it.
--
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