catastrophic error - Mailing list pgsql-admin

From Joel Fradkin
Subject catastrophic error
Date
Msg-id 000a01c55728$8abe41c0$797ba8c0@jfradkin
Whole thread Raw
Responses Re: catastrophic error
Re: catastrophic error
List pgsql-admin

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.

 


 

 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compile Error for postgresql-8.0.3
Next
From: "Goulet, Dick"
Date:
Subject: Re: ACT! and PostgreSQL