Using postgresql with (filesystem) ACLs in linux. - Mailing list pgsql-admin

From toomanyryans
Subject Using postgresql with (filesystem) ACLs in linux.
Date
Msg-id 1302352194151-4292819.post@n5.nabble.com
Whole thread Raw
List pgsql-admin
Hi,

I'm trying to install PostgreSQL using the packages from here:

http://www.openscg.org/se/postgresql/packages.jsp

Those bundles are very close to the way I like to install things on my
continuous integration server.  However, I use an ACL enabled filesystem (to
simplify backups).  PostgreSQL complains and won't start if the data
directory doesn't have 0700 permissions.  Is there a way to force PostgreSQL
to ignore group / world access on the data directory since I know my
permissions are suitable?

For anyone balking at my backups comment, I stop the database server, take a
LVM snapshot and run my backups from the snapshot.  Also, since I want to
use the install for integration testing, the data is not important to me
anyway - it gets discarded.

Any suggestions?

Ryan

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Using-postgresql-with-filesystem-ACLs-in-linux-tp4292819p4292819.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

pgsql-admin by date:

Previous
From: Marcelo Leite
Date:
Subject: Re: DB Import Error...
Next
From: Erwin Brandstetter
Date:
Subject: 20110408pg upgrade fix: How do I know if I am being affected before errors occur