Jonatan Evald Buus
jonatan.buus at cellpointmobile.com
Mon Dec 22 19:36:59 UTC 2008
We are having problems with Record Based Log Shipping from our PostGreSQL
database server that appears to stem from NFS caching the files.
PostGreSQL are continously writing to its WAL files located in the pg_xlog
directory which is shared via NFS
Our program is in turn continously detecting the changes as described in
24.4.4 at http://www.postgresql.org/docs/8.3/static/warm-standby.html and
copying a segment of the WAL file to the local harddisk.
The changes written by PostGreSQL however doesn't appear to be reflected
through the mapped NFS drive until at some later point in time (not sure how
long the delay is, but it appears to be 10+ seconds). The delay causes the
transferred WAL files to become corrupt.
Running the same program directly on the PostGreSQL machine provides the
The following is the NFS configuration on both the Client and Server
sysctl -a |grep nfs
Are there other ways of disabling the NFS' cache than using sysctl?
Preferably at mount time so caching is only disabled for the PostGreSQL
Alternatively, how is NFS forced to use Direct IO?
Appreciate the input
More information about the freebsd-questions