Re: Lost connection after postgres restarted

Hi,

Since we're implementing transparent connection pooling in C-JDBC, you
can run C-JDBC on top of the Postgresql driver
and you'll be able to recover your connection without starting stopping
application.
And since, C-JDBC is basically a cluster, you can replicate your
Postgresql database on multiple backends, and when the
time of backing up has come, only one of your database backend will be
offline during the process, the other ones will still be available.

Maybe you should have a look ...


Nicolas,


---
Nicolas Modrzyk
Software Engineer INRIA Rhone-Alpes
C-JDBC http://c-jdbc.objectweb.org

On Thursday, January 22, 2004, at 09:52 AM, Vámos Balázs wrote:

> Thomas,
>
> And how can I solve this connection pooling problem?
>
> Restarting the application is not good, because this process must be
> automatic instead of manual.
>
> somav
>
>> -----Original Message-----
>> From: pgsql-jdbc-owner@postgresql.org
>> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Paul Thomas
>> Sent: Tuesday, January 20, 2004 8:00 PM
>> To: Vámos Balázs
>> Cc: pgsql-jdbc @ postgresql . org
>> Subject: Re: [JDBC] Lost connection after postgres restarted
>>
>>
>>
>> On 20/01/2004 17:22 Vámos Balázs wrote:
>>> Hi,
>>>
>>> I have the following problem with my PostgreSQL+Tomcat+JDBC:
>>>
>>> I have got a PostgreSQL server, a Tomcat, and some jsp file
>> what connects
>>> to
>>> the postgresql via JDBC.
>>>
>>> I stop postmaster (because of file system level backup)
>>> After the backup I start postmaster
>>> But the connection between JDBC and postgresql doesn't recover any
>>> more.
>>>
>>> I need to restart Tomcat to build up the connection again. Why?
>>
>> IMHO, this is more a limitation of the connection pooling which
>> doesn't
>> seem to be able to recognise that a connection has gone bad and that
>> it
>> should discard it and create a new one. BTW, its not necessary to stop
>> Tomcat as you can use its manager application to simply stop and
>> restart
>> your application.
>>
>> --
>> Paul Thomas
>> +------------------------------+----------------------------------
>> -----------+
>> | Thomas Micro Systems Limited | Software Solutions for the Smaller
>> Business |
>> | Computer Consultants         |
>> http://www.thomas-micro-systems-ltd.co.uk   |
>> +------------------------------+----------------------------------
>> -----------+
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 7: don't forget to increase your free space map settings
>>
>>
>>
>
>
> ---------------------------(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
>
>