On 11 February 2009 c. 17:59:53 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!
>
> Thanks for your help
>
> Tony
PostgreSQL runs under system _postgresql user,
see /usr/local/share/doc/postgresql/README.OpenBSD
--
WBR,
Pereresus ne Vlezaet Buggy
