Re: Postgresql create tablespace permissions problem

[Dan Colish]

> I did the following:
>
> - as '_postgresql' UNIX user I issued psql -d template1 postgres
> - then issued twice the CREATE TABLESPACE cmd as already described and got
> the error (with OWNER defined both 'postgres' and '<DB-user>')
>
> that's all I did!
>
> Thanks
>
> Tony
>
>
You should have a read of /usr/local/share/doc/postgresql/README.OpenBSD
The users that you're using are just wrong. The database is run using
postgres not _postgresql.