Re:
| От | Kalai R |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | CAGxuanMvME0TX+hJAAbj2FN8=0-4TQs_6UQqRmZsxUioco0_Ug@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: (John R Pierce <pierce@hogranch.com>) |
| Ответы |
Re:
|
| Список | pgsql-general |
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@hogranch.com> 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 serviceWhat 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_ctlWho 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
В списке pgsql-general по дате отправления: