Re: Fwd: Tablespace Problem

Sir,

I have tried to change the ownership of the postgres directories to
postgresql account.
But in windows , the posgresql account has no permission to take ownership
of any directory.
Because the postgresql service account is not under any group and not as a
logon account.
How can I set ownership for postgres account?

Thanks in advance.
On Mon, May 3, 2010 at 6:49 PM, justin(at)magwerks(dot)com <justin(at)magwerks(dot)com>wrote:

>
> ---- Message from Kalai R <softlinne(dot)kv(at)gmail(dot)com><softlinne(dot)kv(at)gmail(dot)com>at 05-03-2010 05:41:24 PM ------
>
> Hi,
> Sir,
> I have been checked pg_tblspc/86014 directory have no permission to
> create new folder.
> I am using Windows XP Os and VB.Net frontend. I created the tablespace
> folder by programaticaly using vb.net.
>
> I tried to chang the user permission for that folder by programatically
> and manualy using properties of the folder in windows explorer but folder
> permission not changed.
> Is there any option to solve this problem via postgersql?
>
> If not , Should I change the folder permission for which user? current user
> or service account for postgresql.
>
>
> ***snip***
> the Postgresql account needs to have full control over all its directories
>
> No other account needs access to postgresql directories.
>
> If security does not read as postgres account having full control and you
> can't change security, You need to take ownership of the directories first
> then you can change security.
>
> To take ownership you have to be admin on that computer. Then put postgres
> account as full control.
>
>
> All legitimate Magwerks Corporation quotations are sent in a .PDF file
> attachment with a unique ID number generated by our proprietary quotation
> system. Quotations received via any other form of communication will not be
> honored.
>
> CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain
> legally privileged, confidential or other information proprietary to
> Magwerks Corporation and is intended solely for the use of the individual to
> whom it addresses. If the reader of this e-mail is not the intended
> recipient or authorized agent, the reader is hereby notified that any
> unauthorized viewing, dissemination, distribution or copying of this e-mail
> is strictly prohibited. If you have received this e-mail in error, please
> notify the sender by replying to this message and destroy all occurrences of
> this e-mail immediately.
> Thank you.
>