X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 30A7A53375 for ; Thu, 12 May 2005 16:36:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97686-09 for ; Thu, 12 May 2005 19:36:32 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 4F8C25400F for ; Thu, 12 May 2005 16:36:30 -0300 (ADT) Received: from ool-4350c7ad.dyn.optonline.net ([67.80.199.173] helo=[192.168.0.66]) by outbound.mailhop.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1DWJTy-000HVp-Rp; Thu, 12 May 2005 15:36:30 -0400 Message-ID: <4283B0B4.90800@zeut.net> Date: Thu, 12 May 2005 15:38:28 -0400 From: "Matthew T. O'Connor" Organization: Terrie O'Connor Realtors User-Agent: Mozilla Thunderbird 1.0RC1 (Windows/20041201) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joel Fradkin Cc: pgsql-admin@postgresql.org Subject: Re: catastrophic error References: <000a01c55728$8abe41c0$797ba8c0@jfradkin> In-Reply-To: <000a01c55728$8abe41c0$797ba8c0@jfradkin> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 67.80.199.173 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/172 X-Sequence-Number: 17601 If you could connect to the database server from the web server and get data with PGAdmin then it doesn't' sound like a database or database server problem. How is your web app connecting to the database? ODBC? That might be a bit of an issue. PgAdmin doesn't use ODBC, it uses libpq directly. Joel Fradkin wrote: > Hi, > > > > I have been live for 4 days (vacuums run each night and backups done > each night). > > Today around 2:30 PM EST my web app returned a catastrophic error. > > Both web servers appeared to have the issue. > > I could go on them and get data via pgadmin. > > I could log on the server (IIS servers are win2k and pg is Redhat AS4 > running 8.0.2) and see it was not using much memory or cpu. > > Neither the web or database servers seemed stressed? > > Any ideas what I should look at? > > I re-booted the IIS servers and it did not fix the issue. > > I rebooted the database server and the web servers are back to connecting. > > > > Being new to postgres I am not sure what to look at for the cause and > hopefully permanent fix to this. > > > > Thanks in advance to any ideas (I did search the archive, but only saw > a mention of pre 8 versions and oid numbering wraparound). > > > > Joel Fradkin > > > > Wazagua, Inc. > 2520 Trailmate Dr > Sarasota, Florida 34243 > Tel. 941-753-7111 ext 305 > > > > jfradkin@wazagua.com > www.wazagua.com > Powered by Wazagua > Providing you with the latest Web-based technology & advanced tools. > © 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc > This email message is for the use of the intended recipient(s) and > may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not > the intended recipient, please contact the sender by reply email and > delete and destroy all copies of the original message, including > attachments. > > > > > > > >