On 5/4/21 1:43 PM, Tom Lane wrote:
Greg Stark <st...@mit.edu> writes:
On Mon, 3 May 2021 at 15:44, Tom Lane <t...@sss.pgh.pa.us> wrote:
BTW, as far as that goes, I think the general recommendation is that
the datadir shouldn't be a mount point, because bad things happen if
you mount or unmount the drive while the postmaster is up. I could
see enforcing that, if we could find a reasonably platform-independent
way to do it.
I don't think the problem is unmounting -- on BSD you have to try
really hard to unmount filesystems that have files open on them and
afaik you can't do it on Linux at all (which I still claim is the
original sin that led to the fsync issues).
The problem was mounting filesystems if it happened late -- ie. After
Postgres had started up. It was exacerbated by some startup scripts
that would automatically run initdb if there was nothing present.
Yeah, at least that was the case that somebody (Joe Conway if memory
serves) reported years ago.
Guilty as charged ;-)
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
