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. >
