Re: Backup and failover process

>>> "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