By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 820 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

PostgreSQL Tablespace Creation Problem

P: 24
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
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 700
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

P: 24
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

Expert 100+
P: 700
I tried giving full path also. like C:\tablespace. Still i am not successful
show the full query you write
Nov 21 '07 #4

P: 24
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

Expert 100+
P: 700
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.