Re: can not create a tablespace from psql - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: can not create a tablespace from psql
Date
Msg-id AANLkTi=n0dFGmfbnr1CR6kznyK4Bw23Fp_Q7JCiyvhNC@mail.gmail.com
Whole thread Raw
In response to can not create a tablespace from psql  (hyelluas <helen_yelluas@mcafee.com>)
List pgsql-admin
On Fri, Mar 25, 2011 at 7:10 PM, hyelluas <helen_yelluas@mcafee.com> 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

pgsql-admin by date:

Previous
From: hyelluas
Date:
Subject: can not create a tablespace from psql
Next
From: Tom Lane
Date:
Subject: Re: can not create a tablespace from psql