pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Protect pg_xlog ?
2+ messages / 2 participants
[nested] [flat]

* Protect pg_xlog ?
@ 2004-01-16 13:34 Chris Gamache <cgg007@yahoo.com>
  2004-01-16 15:55 ` Re: Protect pg_xlog ? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Gamache @ 2004-01-16 13:34 UTC (permalink / raw)
  To: pgsql-admin

I have one RAID 1+0 array available. My primary concern is data integrity.

The general instruction is to put pg_xlog on another filesystem, seperated
physically from the database files, for maximum performance. That is what I had
planned on doing. However, it dawned on me that there could be a serious
problem if the pg_xlog got corrupted or was lost in a hardware failure. It
might not matter one bit that the actual data files are safe and sound if the
transaction log is corrupted. 

Is protecting pg_xlog as important as protecting the rest of the data files?

Will the performance hit, which happens when one keeps pg_xlog on the same
filesystem as the database, be substantial enough to warrant spending more
money on another array of drives to use for pg_xlog?

CG

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Protect pg_xlog ?
  2004-01-16 13:34 Protect pg_xlog ? Chris Gamache <cgg007@yahoo.com>
@ 2004-01-16 15:55 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-01-16 15:55 UTC (permalink / raw)
  To: cgg007@yahoo.com; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-01-16 15:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-16 13:34 Protect pg_xlog ? Chris Gamache <cgg007@yahoo.com>
2004-01-16 15:55 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox