Skip site navigation (1) Skip section navigation (2)

Re: postgres data permission

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres data permission
Date: 2010-07-15 15:40:13
Message-ID: 5875.1279208413@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> writes:
> I need to start a postgres istance on a samba filesystems /data which 
> have rwxrwxrwx (777) permissions, Ic ould not change  such permissions.
> If I try to start postgres it complain that should be 700 permission .

> How can I skip this control by postgres startup process and be able to 
> startup istance on this "special folder"??

You can't, and it wouldn't be a good idea even if you could.

I think what you're really saying is that you are trying to create a
Postgres data directory directly on a filesystem mount point.  Don't do
that (it's a large-caliber foot-gun even aside from permissions issues).
Make a subdirectory in the mount point, and use that as the data
directory, and make sure it has the right ownership and permissions.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: David BearDate: 2010-07-15 16:28:51
Subject: Re: postgres data permission
Previous:From: Burgholzer, Robert (DEQ)Date: 2010-07-15 14:49:01
Subject: cache lookup failed for relation (just some data here)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group