From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
---|---|
To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Backup and failover process |
Date: | 2008-07-15 20:20:47 |
Message-ID: | B10E6810AC2A2F4EA7550D072CDE8760CDDE7F@SAB-FENWICK.sab.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)Grittner(at)wicourts(dot)gov]
Sent: Tuesday, July 15, 2008 12:24 PM
To: Campbell, Lance; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Backup and failover process
>>> "Campbell, Lance" <lance(at)illinois(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-07-15 20:38:11 | Re: Backup and failover process |
Previous Message | samantha mahindrakar | 2008-07-15 17:54:00 | Jobs using pgagent |