On Wed, Feb 11, 2009 at 4:13 PM, Jason Dixon <ja...@dixongroup.net> wrote:
> On Wed, Feb 11, 2009 at 03:59:53PM +0100, Tony Berth wrote: > > Dear List, > > > > in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a > > different filesystem and get the following error: > > > > ----------------------------------------------- > > template1=# CREATE TABLESPACE <tbspace-name> OWNER <DB-user> LOCATION > > '/home/<DB-user>/db'; > > ERROR: could not set permissions on directory "/home/<DB-user>/db": > > Permission denied > > ----------------------------------------------- > > > > "/home/<DB-user>/db" does exist and belongs to <DB-user> who has the same > > name in Postgresql and in Unix! > > It sounds to me like "DB-user" is a role account. Any filesystem-level > changes would probably be performed by the _postgresql user that the > database process runs at. > > http://www.postgresql.org/docs/8.3/static/manage-ag-tablespaces.html > > -- > Jason Dixon > DixonGroup Consulting > http://www.dixongroup.net/ > I did assign that directory to '_postgresql' user too but I still get the same error! <DB-user> is indeed a role account and a Unix user! I can't connect via psql using '_postgresql'. I can only connect as 'postgres'! Thanks Tony