On Fri, Mar 25, 2011 at 7:10 PM, hyelluas <helen_yelluas(at)mcafee(dot)com> wrote:
> [root(at)Prof20_52_91 data]# ls -ltr psql
> postgres=# create tablespace my_test1 OWNER postgres location
> '/data/pgsql/my_test1';
> ERROR: could not set permissions on directory "/data/pgsql/my_test1": No
> such file or directory
When you say 'ls', you're in a directory named 'data'. Your CREATE
TABLESPACE statement is looking for '/data/pgsql/my_test1'.
Double-check your path and try again.
rls
--
:wq