I've been having a problem for a while and I don't really have any leads to
investigate. I've got an Enhydra java web application connected to a
PostgreSQL database (this happened with version 7.1.3 as well as 7.2). After
a time of running, usually no more than a week, the database stops accepting
new connections and responds with a message that it's shutting down. I've
checked sys logs, database logs, and application logs but there is no trace
of an error. In the mean time the application continues to run, I presume
because the application's database manager maintains the original
connections. When I have to restart the application, the connections are
released and the database dies. Does this sound familiar to anyone?
--
Jeremy