Re: PITR Questions

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Matthew T(dot) O'Connor <matthew(at)zeut(dot)net>
Cc: Chander Ganesan <chander(at)otg-nc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PITR Questions
Date: 2006-08-18 23:01:58
Message-ID: 0116F61B-4372-4E73-9046-3B68A9ED6EA0@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message felix 2006-08-18 23:19:28 Query optimization and indexes
Previous Message Michael Fuhr 2006-08-18 20:54:19 Re: Connection string