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
