Re: why not using a mountpoint as PGDATA? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: why not using a mountpoint as PGDATA?
Date
Msg-id CAKoxK+57m-8pugYke+BYhYtPn4YYNJgzU8g21aMykEZmMdQgQw@mail.gmail.com
Whole thread Raw
In response to Re: why not using a mountpoint as PGDATA?  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: why not using a mountpoint as PGDATA?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Feb 27, 2019 at 12:33 PM Julien Rouhaud <rjuju123@gmail.com> wrote:
> You can see most obvious reasons at
> https://bugzilla.redhat.com/show_bug.cgi?id=1247477

Thanks, I didn't see the lost+found problem because I'm on UFS (I'm
wondering if this applies also to ZFS datasetes with mount point).
Same story for the accidentally umount, since FreeBSD seems enough
friendly to avoid umount while the database is running, but it could
definetely happen with some brute force or on another operating
system.
I see the upgrade problem being a lot more general in this sense.
However, all are good points.

Luca


pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: why not using a mountpoint as PGDATA?
Next
From: Achilleas Mantzios
Date:
Subject: Re: Barman disaster recovery solution