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

Re: Backup and failover process

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Lance Campbell" <lance(at)illinois(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Backup and failover process
Date: 2008-07-15 20:38:11
Message-ID: 487CC4BB.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> "Campbell, Lance" <lance(at)illinois(dot)edu> wrote: 
 
> What happens if you take an SQL snapshot of a database while
> creating WAL archives then later restore from that SQL snapshot and
> apply those WAL files?
 
What do you mean by "an SQL snapshot of a database"?  WAL files only
come into play for backup techniques which involve file copies, not
dumps done using SQL commands (like pg_dump).
 
> Will there be a problem if the transactions
> within the newest WAL file after the SQL snapshot was taken cause
> problems when they are applied?
 
Point In Time Recovery (PITR) backup techniques allow you to restore
to a specified point in time, so you could restore up to the point
immediately before the problem transactions.
 
> I would assume yes but I wanted to
> check if there was some type of timestamp that would prevent an
issue
> from occurring?
 
Take another look at this section -- in particular,
recovery_target_time.
 
I hope this helps.
 
-Kevin

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-07-15 20:43:47
Subject: Re: Backup and failover process
Previous:From: Campbell, LanceDate: 2008-07-15 20:20:47
Subject: Re: Backup and failover process

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