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: (view raw, whole thread or download thread mbox)
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
> from occurring?
Take another look at this section -- in particular,
I hope this helps.

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-2017 The PostgreSQL Global Development Group