Re: PITR Archive Recovery

From: ohp(at)pyrenet(dot)fr
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: PITR Archive Recovery
Date: 2004-06-30 11:27:21
Message-ID: Pine.UW2.4.53.0406301321170.5052@server.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Dear Simon,

I've been following the PITR thread with great interest since a long time.
I apologie to jump it so late, but there's one question I can't find any
answer for.

Given that log files will be archieved, how can we purge them (ie know for
sure we won't need them anymore)

if I do a backup of the DATA dir, then obviously I won't need the logs
that were taken before. I can't just delete them all because maybe a few
will be archived during the backup.

Same thing goes for pg_dump.

Maybe I've missed something.

Regards, and many thanks for that great feature
On Wed, 30 Jun 2004, Simon Riggs wrote:

> Date: Wed, 30 Jun 2004 02:46:57 +0100
> From: Simon Riggs <simon(at)2ndquadrant(dot)com>
> To: pgsql-patches(at)postgresql(dot)org
> 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
> > >
> > > 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
> earlier patches for pitr_v4_4*, then apply this. (Full patch available
> upon request...just saving the good people of this list some annoyance
> time from a 50k download).
>
> This now provides:
>
> - parsing of restore program from recovery.conf
> - minor cosmetic changes to some error messages
>
> ...there's more to do, but I'm working on the...
> if it ain't broke, don't fix it...
>
> Best Regards, Simon Riggs
>

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Fabien COELHO 2004-06-30 11:33:59 patch queue reminder
Previous Message Tom Lane 2004-06-30 02:32:07 Re: [PATCHES] nested xacts and phantom Xids