pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProtect pg_xlog ?
2+ messages / 2 participants
[nested] [flat]
* Protect pg_xlog ?
@ 2004-01-16 13:34 Chris Gamache <cgg007@yahoo.com>
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 15:55 Tom Lane <tgl@sss.pgh.pa.us>
parent: Chris Gamache <cgg007@yahoo.com>
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