Обсуждение: Question on pg_xlog and pg_control placement
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.
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.