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.

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 <mailto:jfradkin@wazagua.com>
> www.wazagua.com <http://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.
>
>
>
>
>
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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

Any messages in syslog on db server? Any web error logs that you can check?

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org