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/