On 10/19/2017 1:25 PM, Tomas Vondra wrote:
Is it fine to create a subdir inside PGDATA and store our stuff
there, or will PG freak out seeing a foreign object.
PostgreSQL certainly does not check if there are unknown directories in
the data directory, and it will not crash and burn. But it causes all
sorts of problems, and it increases the probability of human error.
most importantly, ONLY the postgres system process should have access to
the pgdata directory, it should have permissions 700. your apps should
be running as a different user, and that user won't have access to said
PGDATA.
--
john r pierce, recycling bits in santa cruz
