From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | recovering from backup + transaction log |
Date: | 2003-11-19 17:17:27 |
Message-ID: | 200311191717.27954.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi folks,
I've been asked this question, and it's about a part of PostgreSQL that I've
not looked at.
Is it possible to recover a database from a dump + some form of transaction
log, i.e. if I pg_dump on a nightly basis, and then at noon the database
crashes, can I take the last dump and roll it forward from a log.
I've had a quick look and seen some info about a write-ahead log, but this
only seems to relate to server crashes.
(Is this to do with the recent Point-in-time recovery, and if so, will we have
to wait for 7.5?)
Any info would be appreciate.
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-11-19 19:27:35 | Re: Automatic null values convertion in INSERT and WHERE statements |
Previous Message | Bruce Momjian | 2003-11-19 16:42:40 | Re: Point-in-time data recovery - v.7.4 |