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.
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 |