Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group