X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 05AB9D1D8A5 for ; Tue, 30 Mar 2004 04:44:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49530-09 for ; Tue, 30 Mar 2004 00:44:17 -0400 (AST) Received: from sambucca.ecomtel.com.au (sambucca.ecomtel.com.au [210.9.56.2]) by svr1.postgresql.org (Postfix) with ESMTP id 65664D1C516 for ; Tue, 30 Mar 2004 00:44:15 -0400 (AST) Received: from malibu.ecomtel.com.au (lintelsys.com.au) [210.9.56.6] by sambucca.ecomtel.com.au with esmtp (Exim 3.35 #1 (Debian)) id 1B8B6i-0006WG-00; Tue, 30 Mar 2004 14:44:12 +1000 Message-ID: <4068FB1B.30004@lintelsys.com.au> Date: Tue, 30 Mar 2004 14:44:11 +1000 From: Alex Satrapa Reply-To: pgsql-admin@postgresql.org Organization: Lintelsys User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040123 Debian/1.6-1.he-1 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Spontaneous PostgreSQL Server Reboot? References: <4068F16C.6050800@e-greek.net> In-Reply-To: <4068F16C.6050800@e-greek.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: Not scanned; (mail.ecomtel.com.au) no attachments X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/383 X-Sequence-Number: 12952 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