Re: Protect pg_xlog ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Protect pg_xlog ?
Date: 2004-01-16 15:55:50
Message-ID: 114.1074268550@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chris Gamache <cgg007(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Larry Rosenman 2004-01-16 16:53:18 Re: [PERFORM] Postgres on Netapp
Previous Message Tom Lane 2004-01-16 15:47:42 Re: can't create db from PHP