From: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com> |
---|---|
To: | pgsql-general general <pgsql-general(at)postgresql(dot)org> |
Cc: | ascot(dot)moss(at)gmail(dot)com |
Subject: | fsync and wal_sync_method |
Date: | 2013-09-12 01:11:21 |
Message-ID: | A3705D4E-F5CD-4FD3-891F-60C1D01218D7@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 machine for 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(at)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 3rd server might not contain the latest WAL. In order to avoid possible data lost, should 'fsync" be turned ON in pg-Master and pg-Slave? if yes what would be the best settings of "wal_sync_method" for these two servers respectively?
Please advise.
regards
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-09-12 01:39:17 | Re: Odd behavior in functions w/ anyarray & anyelement |
Previous Message | James Sewell | 2013-09-12 00:25:02 | Re: pg_largeobjects |