Re: [BUGS] 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