On Fri, Mar 25, 2011 at 7:10 PM, hyelluas <helen_yelluas@xxxxxxxxxx> wrote: > [root@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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
