Tom Lane wrote:
Brandon Craig Rhodes [EMAIL PROTECTED] writes:
And the disputed point:
- If the drive holding the WAL fails, then the database engine
will shut down cleanly by writing everything in RAM out to
the real database tables, and no data will
In planning a Postgresql deployment, our team discovered that we have
different understandings of how the WAL affects database reliability,
and we have not found the Postgresql manual quite explicit enough to
distinguish between the following two theories:
a) Putting the WAL on a separate
Brandon Craig Rhodes [EMAIL PROTECTED] writes:
And the disputed point:
- If the drive holding the WAL fails, then the database engine
will shut down cleanly by writing everything in RAM out to
the real database tables, and no data will be lost.
Whoever
On Tue, 2005-05-03 at 10:30 -0400, Brandon Craig Rhodes wrote:
theories:
a) Putting the WAL on a separate device from the database tables
not only increases efficiency, but reliability as well - because
as long as one keeps a database backup and a WAL history that
goes