On Thu, Jan 30, 2003 at 01:27:59PM -0600, Greg Copeland wrote:
> That was going to be my question too.
>
> I thought NFS didn't have some of the requisite file system behaviors
> (locking, flushing, etc. IIRC) for PostgreSQL to function correctly or
> reliably.
I don't know what locking sheme PostgreSQL use, but in theory it should
be possible to use it over NFS:
- a fflush()/msync() should work the same way on a NFS filesystem as on a
local filesystem, provided the client and server implements the NFS
protocol properly
- locking via temp files works over NFS, again provided the client and server
implements the NFS protocol properly (this is why you can safely read your
mailbox over NFS, for example). If PostgreSQL uses flock or fcntl, it's
a problem.
--
Manuel Bouyer <[EMAIL PROTECTED]>
NetBSD: 24 ans d'experience feront toujours la difference
--
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
