From: | hyelluas <helen_yelluas(at)mcafee(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | can not create a tablespace from psql |
Date: | 2011-03-26 01:10:45 |
Message-ID: | 1301101845051-4265091.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I want to create a tablespace from a command line.
I created the directory and set chmod to 0700 , still could not do it.
I can create a tablespace from Admin GUI, not from psql
I'm using PostgreSQL 8.4.6 on RedHat 5.4
[root(at)Prof20_52_91 data]# ls -ltr psql
total 12
drwx------ 7 postgres root 4096 Mar 24 11:41 profiler
drwx------ 2 postgres postgres 4096 Mar 25 16:50 my_test
drwx------ 2 postgres postgres 4096 Mar 25 16:52 my_test1
[root(at)Prof20_52_91 data]# chmod 0700 /data/psql/my_test1
[root(at)Prof20_52_91 data]# su - postgres
-bash-3.00$ psql
psql (8.4.6)
Type "help" for help.
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
postgres=#
I need to create the tablespace from the script.
thank you for help
Helen
--
View this message in context: http://postgresql.1045698.n5.nabble.com/can-not-create-a-tablespace-from-psql-tp4265091p4265091.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Rosser Schwarz | 2011-03-26 01:17:33 | Re: can not create a tablespace from psql |
Previous Message | Rob Richardson | 2011-03-25 13:18:11 | Postgres ODBC driver 8.04 installation recovery path |