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@xxxxxxxxxxxx] Sent: Tuesday, July 15, 2008 12:24 PM To: Campbell, Lance; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Backup and failover process >>> "Campbell, Lance" <lance@xxxxxxxxxxxx> 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
