469,126 Members | 1,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

PostgreSQL Tablespace Creation Problem

I am not able to create a tablespace in PostgreSQL. what should i mention for Location field. What ever i mention, it gives me error saying Table Space location must be an absolute path.

Thanks in Anticipation
Nov 20 '07 #1
5 10065
rski
700 Expert 512MB
I am not able to create a tablespace in PostgreSQL. what should i mention for Location field. What ever i mention, it gives me error saying Table Space location must be an absolute path.

Thanks in Anticipation
Give a full path for the location of a tablespace
Nov 20 '07 #2
Give a full path for the location of a tablespace
I tried giving full path also. like C:\tablespace. Still i am not successful
Nov 21 '07 #3
rski
700 Expert 512MB
I tried giving full path also. like C:\tablespace. Still i am not successful
show the full query you write
Nov 21 '07 #4
I could create the TS in postgres user. But i was trying to create another TS outside postgres user. which is failing.

I believe i can't create TS in another user . But still was trying to confirm

This was the SQL i used to create TS in postgres

CREATE TABLESPACE "SampleTS"
OWNER postgres
LOCATION 'C:/Documents and Settings/postgres/SampleTS';

And to create TS in another user , which is failing with an error saying "Could not set permissions on directory"

CREATE TABLESPACE "SampleTS1"
LOCATION 'C:/Documents and Settings/Administrator/SampleTS';
Nov 21 '07 #5
rski
700 Expert 512MB
I could create the TS in postgres user. But i was trying to create another TS outside postgres user. which is failing.

I believe i can't create TS in another user . But still was trying to confirm

This was the SQL i used to create TS in postgres

CREATE TABLESPACE "SampleTS"
OWNER postgres
LOCATION 'C:/Documents and Settings/postgres/SampleTS';

And to create TS in another user , which is failing with an error saying "Could not set permissions on directory"

CREATE TABLESPACE "SampleTS1"
LOCATION 'C:/Documents and Settings/Administrator/SampleTS';

User must have 'write right' to this directory.
Nov 21 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jens H. Hamann | last post: by
29 posts views Thread by Paul Ganainm | last post: by
6 posts views Thread by robert | last post: by
reply views Thread by Yuri Ludevig | last post: by
4 posts views Thread by Joachim Klassen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.