Benjamin Wang <benjamin.ah...@gmail.com> writes: > I am not sure whether PostgreSQL depends on system call `fsyncdata` to > sync data to disk. If yes, then I don't think it's safe to use NFS.
Well, that's a whole other discussion. The point about mount
directories applies to any sort of dismountable storage.
(But I too would not use Postgres-over-NFS for any critical data.
Too many moving parts. It's tough enough to ensure crash safety
with local storage.)
regards, tom lane
