From: hyelluas <helen_yelluas@mcafee.com>
To: pgsql-admin@postgresql.org
Subject: can not create a tablespace from psql
Date: Fri, 25 Mar 2011 18:10:45 -0700 (PDT)
Message-ID: <1301101845051-4265091.post@n5.nabble.com> (raw)
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@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@Prof20_52_91 data]# chmod 0700 /data/psql/my_test1
[root@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: helen_yelluas@mcafee.com
Subject: Re: can not create a tablespace from psql
In-Reply-To: <1301101845051-4265091.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox