hyelluas <helen_yelluas@xxxxxxxxxx> writes: > I want to create a tablespace from a command line. > I created the directory and set chmod to 0700 , still could not do it. > [root@Prof20_52_91 data]# chmod 0700 /data/psql/my_test1 ... that says "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 ... that says "pgsql" ... regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin