Using postgresql with (filesystem) ACLs in linux.

From: toomanyryans <ryan+nabble(at)jptech(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Using postgresql with (filesystem) ACLs in linux.
Date: 2011-04-09 12:29:54
Message-ID: 1302352194151-4292819.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message Erwin Brandstetter 2011-04-09 14:21:03 20110408pg upgrade fix: How do I know if I am being affected before errors occur
Previous Message Marcelo Leite 2011-04-09 12:27:31 Re: DB Import Error...