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 6D81653395 for ; Thu, 12 May 2005 16:26:30 -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 96792-05 for ; Thu, 12 May 2005 19:26:27 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id E531A53375 for ; Thu, 12 May 2005 16:26:25 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id ADE1073C; Thu, 12 May 2005 15:26:25 -0400 From: "Joel Fradkin" To: Subject: catastrophic error Date: Thu, 12 May 2005 15:26:48 -0400 Message-ID: <000a01c55728$8abe41c0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000B_01C55707.03ACA1C0" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: * X-Archive-Number: 200505/170 X-Sequence-Number: 17599 This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C55707.03ACA1C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. C 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. ------=_NextPart_000_000B_01C55707.03ACA1C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.

 


 

 

------=_NextPart_000_000B_01C55707.03ACA1C0--