Jeremy,
One place to start is to look in the postgres server logs and find out
why it is shutting down.
Also why would the backend stop giving connections? Are you not closing
connections?
Dave
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Jeremy
> Sent: Monday, March 25, 2002 11:41 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] server shutting down
>
>
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo@postgresql.org so that your message can get through
> to the mailing list cleanly
>
>