fsync and wal_sync_method

Поиск
Список
Период
Сортировка
От ascot.moss@gmail.com
Тема fsync and wal_sync_method
Дата
Msg-id A3705D4E-F5CD-4FD3-891F-60C1D01218D7@gmail.com
обсуждение исходный текст
Ответ на invalid resource manager ID in primary checkpoint record  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Ответы Re: fsync and wal_sync_method  (bricklen <bricklen@gmail.com>)
Список pgsql-general
Hi,

I am using pg 9.2.4 and ubuntu 12.04 to set up a pair of pg-Master and pg-Slave with streaming replication.

The archive_command is enabled and the "rsync" is used in pg-Master to save all its archived WAL files to the 3rd
machinefor backup purpose,  by default, both fsync and wal_sync_method are commented out in postgresql.conf: 

archive_command = '(cp %p /usr/pg_arcxlog/%f && rsync -aq  %p pg@pg_slave:/usr/pg_arcxlog/%f'
#fsync = on                        # turns forced synchronization on or off
#wal_sync_method = fsync        # the default is the first option

Thus I think the latest WAL might not be flushed to disk from time to time in pg-Master, therefore the WAL saved in the
3rdserver might not contain the latest WAL. In order to avoid possible data lost, should 'fsync" be turned ON in
pg-Masterand pg-Slave?  if yes what would be the best settings of "wal_sync_method" for these two servers respectively? 

Please advise.
regards

В списке pgsql-general по дате отправления:

Предыдущее
От: James Sewell
Дата:
Сообщение: Re: pg_largeobjects
Следующее
От: David Johnston
Дата:
Сообщение: Re: Odd behavior in functions w/ anyarray & anyelement