Re: BUG #4339: The postgreSQL service stops abnormally

Hello Markus,

Thanks for the reply.

For the past one week postgreSQL service has been running absolutely fine
-:)

Also there is no OOM killer application on the windows 2003 server. I
haven't made any changes on the machine since first the service failed.

Nothing in the event logs also.

Can there be any another reason why the service failed ?

 --
Thanks and Regards

Bhaskar Sirohi
bhaskar.sirohi@druvaa.com
www.druvaa.com
(C) +91 986 094 6619


On Tue, Aug 5, 2008 at 5:50 PM, Markus Wanner <markus@bluegap.ch> wrote:

> Hi,
>
> Bhaskar Sirohi wrote:
> > ...
>
>> 2008-07-30 15:05:01 EDT LOG:  checkpoints are occurring too frequently (28
>> seconds apart)
>> 2008-07-30 15:05:01 EDT HINT:  Consider increasing the configuration
>> parameter "checkpoint_segments".
>> 2008-07-30 15:13:34 EDT LOG:  checkpoints are occurring too frequently (29
>> seconds apart)
>> 2008-07-30 15:13:34 EDT HINT:  Consider increasing the configuration
>> parameter "checkpoint_segments".
>> 2008-07-30 15:18:50 EDT LOG:  checkpoints are occurring too frequently (28
>> seconds apart)
>> 2008-07-30 15:18:50 EDT HINT:  Consider increasing the configuration
>> parameter "checkpoint_segments".
>> 2008-07-30 15:19:21 EDT LOG:  received fast shutdown request
>>
>
> These log lines look like your database is touching lots of tuples,
> requiring it to checkpoint frequently. Then it receives a fast shutdown
> request - from whoever.
>
> What causes the workload? Did you check memory usage? (And uh.. does
> Windows 2003 Server have an OOM Killer or some such?)
>
> Regards
>
> Markus Wanner
>