Re: Fwd: Tablespace Problem

Sir,

The problem has solved. Thank You so much.

Regards
Gloier

On Tue, May 4, 2010 at 1:00 AM, justin(at)magwerks(dot)com <justin(at)magwerks(dot)com>wrote:

> Postgresql account does not need to own the directory just have full
> control. If you can't change security settings or take/assign ownership
> then the account doing this is not a Administrative account, or security up
> the chain of directories has some mighty odd settings which means resetting
> each directory up the chain one at a time to you reach the root. The
> process is take owner ship then rest security to what it was originally.
>
> As your in the Program Files directory tread lightly because security can
> block service accounts Local Services, System & Network making the machine
> unbootable
>
> When you installed PostgreSQL the windows account postgres should have been
> created and put into the User group with the option to log in as a Service.
>
> What account is Postgresql using to start under, if postgres does not exist
> ???
>
> What ever account the service Postgresql is using to start up under needs
> to have full control of
> c:/program files/progresql
> and what ever table space directories there are created.
>
> if the table spaces are on another Drive make sure the root has the
> account/group postgres is in has permissions to list directories, and
> contents. If not the account will be blocked from reading the drive
> contents regardless what child directories security states.
>
>
>
>
> ---- Message from Kalai R <softlinne(dot)kv(at)gmail(dot)com><softlinne(dot)kv(at)gmail(dot)com>at 05-04-2010 12:02:19 AM ------
>
> 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.
>>
>
>
>
>
> 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.
>