Re: Spontaneous PostgreSQL Server Reboot?

Andrew Biagioni wrote:
> On three different machines running the same PostgreSQL version (7.3.5)
> on Linux and almost identical databases, I have been plagued by
> occasional, unexplainable (to me) reboots of the computer.

1) Do you have a software watchdog that is configured to reboot the machine when it isn't tickled? The watchdog might
possiblybe rebooting because the machine is under heavy load, or perhaps someone forgot to enable the watchdog tickler. 

2) Was there anyone in the machine room at the time?  One office that I worked in suffered random power outages to
severalmachines for weeks on end, until we figured out that the cleaner was unplugging the main Ethernet switch to use
thepower point for their vacuum cleaner. 

3) Are the power supplies up to scratch?  some power supplies just can't handle the load when you run disk and
processorheavily for minutes on end. The result is the same as a brown-out or black-out - power disappears, machine
reboots.

Hope this helps prod someone's memory!
Alex