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

Re: Re: Backup and Recovery

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Backup and Recovery
Date: 2001-07-05 16:13:40
Message-ID: 4.2.2.20010705091116.00a9e270@logic1design.com (view raw or flat)
Thread:
Lists: pgsql-hackers
At 11:04 AM 7/4/01 -0400, Bruce Momjian wrote:
> > > All that is missing is a program, that can take a consistent physical
> > > snapshot (as it was after a particular checkpoint) and would replay
> > > the WAL after a restore of such a snapshot. This replay after a
> > > consistent snapshot is probably as simple as making the WAL files
> > > available to the standard startup rollforward (redo) mechanism, that
> > > is already implemented.
> >
You would also have to have some triggering method that would not allow 
WAL's to be overwritten, and make sure they are sent to some device before 
that happen.  In addition, you'd have to anchor the LOGS against the dumped 
database, so it would know exactly which log to start with when replaying 
against any given archive.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242 


In response to

pgsql-hackers by date

Next:From: John MooreDate: 2001-07-05 16:48:35
Subject: Re: [OT] Any major users of postgresql?
Previous:From: Tom LaneDate: 2001-07-05 16:10:51
Subject: Re: Using Explain

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