Re: Cannot Create a TableSpace on Windows XP Service Pack 2

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Jose Flores
Sent: 04 December 2004 12:10
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Cannot Create a TableSpace on Windows
XP Service Pack 2


Windows XP SP2 came with a lot of security patchs.
Something was changed on the way folders are managed, i don't
know what.

Using pgAdmin III 1.2 RC2, when i want to create a Table Space
with:
CREATE TABLESPACE "TestTS" LOCATION
'E:\\Proyecto2005\\Databases';
i have the following error:
ERROR: Could not set permissions on directory
"E:/proyecto2005/Databases

User i currently has on WinXP belongs to administrators group,
so i must not have problems creating folders or files anywhere.
Yesterday i've installed PostgreSQL 8 beta 5 without problems
and i see two tablespaces pg_default and pg_global

Hi,

This is more of a PostgreSQL issue than pgAdmin, but, although the user
you are running as has permission to create the required directory, it
is not you that is actually doing it - the server is doing it on your
behalf. Because the server runs under a user account without admin
privileges (it won't even start with them), perhaps that user doesn't
have the required rights?

So, the quick fix is to make sure your postgres user (or whatever you
called it) has permission to write to the target directory.

Regards, Dave