Question on pg_xlog and pg_control placement

Поиск
Список
Период
Сортировка
От Richard Sickler
Тема Question on pg_xlog and pg_control placement
Дата
Msg-id f2b12cc10905061352h7c134c3bn1d86c0d1a73b32cf@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Peter Much
Дата:
Сообщение: WARNING: silent data corruption possible from PL/ruby 0.5.0 (after Ruby upgrade)
Следующее
От: Miguel Miranda
Дата:
Сообщение: date ranges in where