From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Stefan Balzter" <ste_ba(at)web(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Tablespaces with Windows 2000 |
Date: | 2005-11-30 15:38:06 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE92E8CC@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I'm having a hard time trying to create a tablespace with
> Windows 2000 and PostgreSQL 8. Is there a How-To somewhere on
> the Net? I only find tablespace issues with Linux. One
> article even claimed it was impossible with Windows, but
> since I've tried it successfully in a localhost installation
> with WinXP, I know this isn't true.
>
> The equivalent of the "owner" of a directory in Windows seems
> to be the one who created it. IOW, when I created a
> tablespace with WinXP in a directory that the owner of the
> postmaster service had created, it worked. In another
> directory, it wouldn't work. However, somehow I can't get it
> to work in a client-server environment with a Win 2000 server.
> Any suggestions?
Picking this one up very late - perhaps you've already got a response.
If not, here's my take:
In general, it's the service account that has to have permissions. When
you say client/service, do you mean you want to create a tablespace on a
network drive? If so, not supported. If you mean you connect with psql
(or pgadmin, or whatever) across the network and create a tablespace
that's local to the server, that should work fine.
If it's the second, verify that the service user has permissions on *all
parent directories to the tablespace directory*. The service account wil
nee dread access all the way up to the final directory, where it needs
full control.
Oh, and make sure all the filesystems are NTFS - tablesspaces is not
supported on any other filesystems.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2005-11-30 15:44:36 | Limits |
Previous Message | Alvaro Herrera | 2005-11-30 13:18:24 | Re: [SQL] Archives site down? |