Re: [ADMIN] Backup and failover process

Kevin,
I have read this documentation. I still does not answer my basic
question. 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? 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? I would assume yes but I wanted to
check if there was some type of timestamp that would prevent an issue
from occurring?

Thanks,

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Tuesday, July 15, 2008 12:24 PM
To: Campbell, Lance; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup and failover process

>>> "Campbell, Lance" <lance@illinois.edu> wrote:
> PostgreSQL: 8.2
> I am about to change my backup and failover procedure from dumping a
full
> file SQL dump of our data every so many minutes

You're currently running pg_dump every so many minutes?

> to using WAL files.

Be sure you have read (and understand) this section of the docs:

http://www.postgresql.org/docs/8.2/interactive/backup.html

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin