Sir, The problem has solved. Thank You so much.
Regards Gloier On Tue, May 4, 2010 at 1:00 AM, jus...@magwerks.com <jus...@magwerks.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...@gmail.com><softlinne...@gmail.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, jus...@magwerks.com > <jus...@magwerks.com>wrote: > >> >> ---- Message from Kalai R <softlinne...@gmail.com><softlinne...@gmail.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. >