Re: Protect pg_xlog ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Protect pg_xlog ?
Date
Msg-id 114.1074268550@sss.pgh.pa.us
Whole thread Raw
In response to Protect pg_xlog ?  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
Chris Gamache <cgg007@yahoo.com> writes:
> It might not matter one bit that the actual data files are safe and
> sound if the transaction log is corrupted.

There's always pg_resetxlog.

However, if you value data integrity over performance, it'd probably be
better to have data+log on one redundant array than to have data on a
redundant array and log on a single nonredundant disk.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: can't create db from PHP
Next
From: kandiah ratnavale
Date:
Subject: problem creating user