Dear PostgreSQL admin'ers,
Our group at OSDL have been porting our DBT test kits to PostgreSQL.
In getting up to speed on PostgreSQL, we have not found a way to recover
from a serious database failure (disk corruption, disk/volume failure).
The following scenario described in the 7.3 docs
Right. We need point-in-time-recovery. Someone is working on it and we
hope to have it for 7.5.
---
Mary Edie Meredith wrote:
Dear PostgreSQL admin'ers,
Our group at OSDL have been porting our DBT test kits to
/a58396/ch13.htm)
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 14:16
To: Mary Edie Meredith
Cc: [EMAIL PROTECTED]; osdldbt-general
Subject: Re: [ADMIN] Seeking information about backup/recovery
Right. We need point-in-time-recovery
Murthy Kambhampaty wrote:
IMHO, while point-in-time recovery would be great to have, there are many
applications that benefit from having online backup and recovery without
needing log roll-forward. For example, Oracle contrasts Full Database
Point-in-time Recovery, the feature mentioned by
On Thursday, September 04, 2003 18:12, Bruce Momjian
[mailto:[EMAIL PROTECTED]
Murthy Kambhampaty wrote:
...
I assume you are contrasting _any_ point-in-time recovery to recover up
to the crash point, right?
Right.
Anyway, unfortunately, WAL doesn't contain enough information
to recover
without
Murthy Kambhampaty wrote:
Anyway, unfortunately, WAL doesn't contain enough information
to recover
without having the file system files in some consistent state, even if
that state is old. In fact, the files have to be consistent as of the
last checkpoint.
This, I'm not so sure of. On