Обсуждение: BUG #1488: CREATE TABLESPACE does not work
The following bug has been logged online: Bug reference: 1488 Logged by: Jesper Udby Email address: jesper_pg@judby.dk 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.)
Jesper Udby wrote: > > The following bug has been logged online: > > Bug reference: 1488 > Logged by: Jesper Udby > Email address: jesper_pg@judby.dk > 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
>The following bug has been logged online: > >Bug reference: 1488 >Logged by: Jesper Udby >Email address: jesper_pg@judby.dk >PostgreSQL version: 8.0.1 >Operating system: Win32 XP Pro SP2 >Description: CREATE TABLESPACE does not work >Details:=20 > >Hello. > >Trying to create a tablespace fails with msg "ERROR: could not set >permissions on directory "...": Permission denied". > >E.g.=20 > >CREATE TABLESPACE pgtest LOCATION 'c:\\pgtest'; > >(Directory c:\\pgtest exists and is readable etc.) What are the permissions on c:\pgtest and what are they on c:\? For the postgres service account, of course. //Magnus