Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group