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.
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 <pierce@xxxxxxxxxxxx> wrote:
why not use the installer, which sets it all up correctly for you?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
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
