Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 435FC1337B49 for ; Fri, 25 Mar 2011 22:10:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14925-07 for ; Sat, 26 Mar 2011 01:10:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id B3551133616B for ; Fri, 25 Mar 2011 22:10:45 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1Q3I1d-0004ND-27 for pgsql-admin@postgresql.org; Fri, 25 Mar 2011 18:10:45 -0700 Date: Fri, 25 Mar 2011 18:10:45 -0700 (PDT) From: hyelluas To: pgsql-admin@postgresql.org Message-ID: <1301101845051-4265091.post@n5.nabble.com> Subject: can not create a tablespace from psql MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201103/243 X-Sequence-Number: 37115 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.