From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Lance Campbell <lance@illinois.edu>
To: pgsql-admin@postgresql.org
Subject: Re: Backup and failover process
Date: Tue, 15 Jul 2008 15:38:11 -0500
Message-ID: <487CC4BB.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760CDDE7F@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE87601970FD@SAB-FENWICK.sab.uiuc.edu>
<487C9741.EE98.0025.0@wicourts.gov>
<B10E6810AC2A2F4EA7550D072CDE8760CDDE7F@SAB-FENWICK.sab.uiuc.edu>
>>> "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, lance@illinois.edu
Subject: Re: Backup and failover process
In-Reply-To: <487CC4BB.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox