fsync and wal_sync_method

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

In response to

Responses

Browse pgsql-general by date

  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