Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Benjamin Wang <benjamin.ahrtr@gmail.com>
Cc: "Peter J. Holzer" <hjp-pgsql@hjp.at>, pgsql-general@lists.postgresql.org
Date: 2025-07-14T19:10:45Z
Lists: pgsql-general
Benjamin Wang <benjamin.ahrtr@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