Re: Big 7.4 items - Mailing list pgsql-hackers

From Greg Copeland
Subject Re: Big 7.4 items
Date
Msg-id 1040049473.26706.231.camel@mouse.copelandconsulting.net
Whole thread Raw
In response to Re: Big 7.4 items  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Big 7.4 items
List pgsql-hackers
On Mon, 2002-12-16 at 08:20, Shridhar Daithankar wrote:
> On Monday 16 December 2002 07:43 pm, you wrote:
> > Consider that on the slave which is now the active server (master dead),
> > it's possible that the slave's PITR's will be recycled before the master
> > can come back up.  As such, unless there is a, an archival process for
> > PITR or b, a method of streaming PITR's off for archival, the odds of
> > using PITR to recover the master (resync if you will) seem greatly
> > reduced as you will be unable to replay PITR on the master for
> > synchronization.
> 
> I agree. Since we are talking about features in future release, I think it 
> should be added to TODO if not already there.
> 
> I don't know about WAL numbering but AFAIU, it increments and old files are 
> removed once there are enough WAL files as specified in posgresql.conf. IIRC 
> there are some perl based replication project exist already which use this 
> feature.
> 

The problem with this is that most people, AFAICT, are going to size WAL
based on their performance/sizing requirements and not based on
theoretical estimates which someone might make to allow for a window of
failure.  That is, I don't believe increasing the number of WAL's is
going to satisfactorily address the issue.


-- 
Greg Copeland <greg@copelandconsulting.net>
Copeland Computer Consulting



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Creating a zero-column table
Next
From: Shridhar Daithankar
Date:
Subject: Re: Big 7.4 items