*why not use the installer, which sets it all up correctly for you?* In previous, I use installer. but I face more data corruption problem and also server starting problem when shutting down the system. so I try to install my self.
*I think the problem is, you ran initdb as your user account, but the system service is running as the special system accounbt NETWORK_SERVICE, or similar, and there may be files in the data directory which the NETWORK_SERVICE account doesn't have write access writes to. you can probably fix this with the cacls command.* I think you are correct. But I want to know why database corrupted even though I shutting down the machine properly. This is frequently happen when I use installer also. On Wed, Jul 23, 2014 at 11:55 AM, John R Pierce <pie...@hogranch.com> wrote: > On 7/22/2014 11:14 PM, Kalai R wrote: > > > > *Well the above would indicate it is not being shutdown properly. How are > you shutting it down?* > > PSQL server starterd as stoped by postgresql windows service. So when I > shutdown the machine postgres shutting down by postgres windows service > > *What and how are you installing?* > > Using windows binary zip file, I extract zip file and create cluster > using intidb then register windows service using pg_ctl > > *Who are you running the service as?* > > I try to start the psql server from command prompt using pg_ctl.exe > > > why not use the installer, which sets it all up correctly for you? > > I think the problem is, you ran initdb as your user account, but the > system service is running as the special system accounbt NETWORK_SERVICE, > or similar, and there may be files in the data directory which the > NETWORK_SERVICE account doesn't have write access writes to. you can > probably fix this with the cacls command. > > > > > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > >
