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! Thanks for your help Tony
