Re: Backup and failover process - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Backup and failover process
Date
Msg-id 487CC4BB.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Backup and failover process  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
>>> "Campbell, Lance" <lance@illinois.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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Backup and failover process
Next
From: Alvaro Herrera
Date:
Subject: Re: More Autovacuum questions