BUG #1488: CREATE TABLESPACE does not work

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:

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.)

What are the permissions on c:\pgtest and what are they on c:\? For the
postgres service account, of course.

//Magnus