Jesper Udby wrote: > > The following bug has been logged online: > > Bug reference: 1488 > Logged by: Jesper Udby > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: Win32 XP Pro SP2 > Description: CREATE TABLESPACE does not work > Details: > > Hello. > > Trying to create a tablespace fails with msg "ERROR: could not set > permissions on directory "...": Permission denied". > > E.g. > > CREATE TABLESPACE pgtest LOCATION 'c:\\pgtest'; > > (Directory c:\\pgtest exists and is readable etc.)
My bet is that the owner of the directory is not the same as the owner of the pg server. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])