From: | Andy Corteen <lbc(at)telecam(dot)demon(dot)co(dot)uk> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Fwd: Re: Timeouts on connections |
Date: | 2001-01-29 11:54:24 |
Message-ID: | 267775557.20010129115424@telecam.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Postgres gurus,
Can anyone shed some light on this one from the PostgreSQL end of
things?
This is a forwarded message
From: Graham Fountain <graham(at)fcot(dot)com>
To: zeos(at)perio(dot)unlp(dot)edu(dot)ar <zeos(at)perio(dot)unlp(dot)edu(dot)ar>
Date: Saturday, January 27, 2001, 10:09:30 PM
Subject: [zeos] Timeouts on connections
===8<==============Original message text===============
I have an application that does this too - only at the moment my app isn't
using Zeos, it uses the ODBC library through the BDE, so I am assuming then
that it is something to do with the back-end server. Up until seeing your
message I thought maybe it was something to do with the ODBC. I'll now be
looking at the compile options of postgres to see if there is a setting in
there.
Perhaps another solution would be to have a function that is triggered by a
TTimer, perhaps every half hour that just does a simple query, that way it
isn't having excessively long inactive times.
BTW... I haven't converted to Zeos from ODBC yet - I'm a little afraid of
the nightmare that it would involve, but can anyone advise whether it would
provide a serious speed benefit, and is it more robust?
Regards,
Graham
----- Original Message -----
From: "Andy Corteen" <lbc(at)telecam(dot)demon(dot)co(dot)uk>
To: "Zeos mailing list" <zeos(at)perio(dot)unlp(dot)edu(dot)ar>
Sent: Saturday, January 27, 2001 3:57 AM
Subject: [zeos] Timeouts on connections
> I have an application that can remain open on a user's desktop all
> day, which the users like (startup times etc...). This is a pilot of a
> conversion to SQL from a tables-based solution that has worked well
> for several years.
>
> After maybe an hour or so of inactivity, the back-end connection to
> Postgres (7.0.3 on RH Linux 6.2) closes, and the application is then
> useless until restarted - I was unaware of this possibility, therefore
> have not coded anything to deal with it.
>
> Is there an event that declares that the back-end has disconnected?
> and/or is there some simple test that will allow me to probe that the
> connection is still live before asking for the data, so that the users
> are unaware of these "background" issues that do not concern them?
>
> --
> Best regards,
> Andy mailto:lbc(at)telecam(dot)demon(dot)co(dot)uk
>
>
> To unsubscribe mail to
> zeos-request(at)perio(dot)unlp(dot)edu(dot)ar with 'unsubscribe' as the subject
> home page: http://www.zeos.dn.ua
>
>
===8<===========End of original message text===========
--
Best regards,
Andy mailto:lbc(at)telecam(dot)demon(dot)co(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Evelio Martinez | 2001-01-29 12:11:47 | Problems with authentication and some questions |
Previous Message | Joseph | 2001-01-29 11:48:02 | Rule problem with access 97 |