Question on pg_xlog and pg_control placement

From: Richard Sickler <richard(dot)sickler(at)avagotech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question on pg_xlog and pg_control placement
Date: 2009-05-06 20:52:27
Message-ID: f2b12cc10905061352h7c134c3bn1d86c0d1a73b32cf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-05-06 20:53:07 Re: [GENERAL] how to select temp table
Previous Message Tom Lane 2009-05-06 20:46:48 Re: [GENERAL] how to select temp table