Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-12-02 Thread Christopher Kings-Lynne
I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines as causing significant confusion during restore, which is the last thing we want to do. I think that judgment is exactly backward. *Not* having timelines is what will cause

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-12-02 Thread Christopher Kings-Lynne
Please ignore- seems some old mail of mine got sent waaay late... Christopher Kings-Lynne wrote: I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines as causing significant confusion during restore, which is the last thing we want

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-14 Thread Simon Riggs
On Wed, 2004-07-14 at 05:45, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think that judgment is exactly backward. *Not* having timelines is what will cause serious and possibly fatal mistakes during restore: people will hand the wrong xlog files to restore

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-14 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think that judgment is exactly backward. *Not* having timelines is what will cause serious and possibly fatal mistakes during restore: people will hand the wrong xlog files to restore and the software will be

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-14 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think it's really important to get this right the first time, both for reliability's sake and because we are expecting people to write their own archiving scripts. If we change the xlog segment naming convention later on, then we will

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-14 Thread Simon Riggs
On Wed, 2004-07-14 at 16:00, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think it's really important to get this right the first time, both for reliability's sake and because we are expecting people to write their own archiving scripts. If we change the xlog

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Simon Riggs
Following a suggestion and patch from Klaus Naumann, the recovery.conf file can now accept comments No patch supplied at present (anoncvs is down), but here is the annotated recovery.conf.sample Best Regards, Simon Riggs # --- # PostgreSQL recovery config file #

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Simon Riggs
On Tue, 2004-07-13 at 23:58, Bruce Momjian wrote: Simon Riggs wrote: New release of patch, at v5_1 ... for serious testing what's in - Point in Time Recovery now worksplease check carefully - additional options in recovery.conf (including code contributed to PITR from Klaus

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Bruce Momjian
Simon Riggs wrote: New release of patch, at v5_1 ... for serious testing what's in - Point in Time Recovery now worksplease check carefully - additional options in recovery.conf (including code contributed to PITR from Klaus Naumann) what's not (yet) - Timelines...though I think they

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Simon Riggs wrote: what's not (yet) - Timelines...though I think they are useful, they may not be critical I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines as causing significant

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Simon Riggs wrote: what's not (yet) - Timelines...though I think they are useful, they may not be critical I am not fond of the timeline idea, especially for 7.5. Let's get usage cases submitted first. I can imagine timelines

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-13 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think that judgment is exactly backward. *Not* having timelines is what will cause serious and possibly fatal mistakes during restore: people will hand the wrong xlog files to restore and the software will be unable to recognize the

Re: [PATCHES] PITR Archive Recovery plus WIP PITR

2004-07-09 Thread Simon Riggs
On Fri, 2004-07-09 at 12:53, Klaus Naumann wrote: archive_program is provided with a string which contains the target directory. That doesn't really make sense. archive_dest is used for both archive and restore, thats why its set as a separate parameter. Thats the rationale...lets see what

Re: [PATCHES] PITR Archive Recovery

2004-07-01 Thread ohp
Many thanks for your reply Simon On Wed, 30 Jun 2004, Simon Riggs wrote: Date: Wed, 30 Jun 2004 19:29:14 +0100 From: Simon Riggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PATCHES] PITR Archive Recovery On Wed, 2004-06-30 at 12:27, [EMAIL PROTECTED] wrote

Re: [PATCHES] PITR Archive Recovery

2004-06-30 Thread ohp
, Simon Riggs wrote: Date: Wed, 30 Jun 2004 02:46:57 +0100 From: Simon Riggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [PATCHES] PITR Archive Recovery On Tue, 2004-06-29 at 20:59, Simon Riggs wrote: On Mon, 2004-06-28 at 21:58, Simon Riggs wrote: PITR Archive Recovery, 28 June 2004

Re: [PATCHES] PITR Archive Recovery

2004-06-30 Thread Simon Riggs
On Wed, 2004-06-30 at 12:27, [EMAIL PROTECTED] wrote: Given that log files will be archieved, how can we purge them (ie know for sure we won't need them anymore) Good question - you're right I've not mentioned that. The answer is straightforward. Whenever you do a backup, one of the

Re: [PATCHES] PITR Archive Recovery

2004-06-29 Thread Simon Riggs
On Mon, 2004-06-28 at 21:58, Simon Riggs wrote: PITR Archive Recovery, 28 June 2004 What's in this patch? - All of what was in previous PITR Archival patch, including reworking of all the archiver startup/shutdown code to match that of pgstat - New code to perform Archive Recovery mode,

Re: [PATCHES] PITR Archive Recovery

2004-06-29 Thread Simon Riggs
On Tue, 2004-06-29 at 20:59, Simon Riggs wrote: On Mon, 2004-06-28 at 21:58, Simon Riggs wrote: PITR Archive Recovery, 28 June 2004 What's in this patch? This my LAST, PLANNED patch before Freeze. Any questions? This is a patch-on-patch, rather than a full patch. To use this, apply