From: Andrew Biagioni <andrew.biagioni@e-greek.net>
To: pgsql-admin@postgresql.org
Subject: Re: Spontaneous PostgreSQL Server Reboot?
Date: Tue, 30 Mar 2004 08:47:36 -0500
Message-ID: <40697A78.6070701@e-greek.net> (raw)
In-Reply-To: <4068FB1B.30004@lintelsys.com.au>
References: <4068F16C.6050800@e-greek.net>
<4068FB1B.30004@lintelsys.com.au>
Alex,
the answer is "no" to all of these. We are a tiny start-up (2 guys, and
we do our own cleaning); ambient temperature varies significantly but
is not related to the failure, and one machine starts beeping when it
gets too hot (then we added an extra case fan); no fancy watchdogs
(maybe someday... One can only dream :-> ); three different cases,
power supplies, motherboards, etc., etc. (one power supply is
extra-large, and that's the machine that started failing first!).
We originally blamed the problem on hardware failure (first machine);
then on OS version/configuration (second machine); now we're out of
things to blame, except maybe unusually bad luck...
Thanks,
Andrew
Alex Satrapa wrote:
> 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 possibly be 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 several machines for weeks on
> end, until we figured out that the cleaner was unplugging the main
> Ethernet switch to use the power 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 processor heavily 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
> .
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andrew.biagioni@e-greek.net
Subject: Re: Spontaneous PostgreSQL Server Reboot?
In-Reply-To: <40697A78.6070701@e-greek.net>
References: <4068F16C.6050800@e-greek.net> <4068FB1B.30004@lintelsys.com.au> <40697A78.6070701@e-greek.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox