Question on pg_xlog and pg_control placement - Mailing list pgsql-general

From Richard Sickler
Subject Question on pg_xlog and pg_control placement
Date
Msg-id f2b12cc10905061352h7c134c3bn1d86c0d1a73b32cf@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,

I'm installing a new 8.3.7 system and have a question on placement locations for pg_xlog and pg_control.

I've read in the documentation pertaining to pg_xlog, that it may be "...of advantage if the log is located on another disk than the main database files."

As PostGRES is installed on one physical disk, and my database is on a second, dedicated physical disk, I thought the above seemed like good advice.  In that way if the disk that the WAL is located on breaks, I can install a replacement disk, restore my last backup, and use the WAL to get back to where I was.  Great.  Ah, then I read that the pg_control file contains the last checkpoint, and the checkpoint is used in the REDO operation.

Should the pg_control file also be moved to the non-database disk?  Any other file moves recommended?  Thank you.

Drive A  would contain POSTGRES binaries,  pg_xlog, and pg_control
Drive B  would contain base, global, pg_clog, etc.


Rich S.

pgsql-general by date:

Previous
From: Peter Much
Date:
Subject: WARNING: silent data corruption possible from PL/ruby 0.5.0 (after Ruby upgrade)
Next
From: Miguel Miranda
Date:
Subject: date ranges in where