Re: [Sqlrelay-discussion] how to ask sqlrelay if the database is not available

[David M. <dav...@fi...>]

For the first one, you could do a ping() before running the query.  If
the ping() returns false then the database is down and you could display
the other page.

For the second one, I'll have to look into that.  Thanks for finding it.
 Hopefully I'll get it sorted out for the next release.

Dave
dav...@fi...

On Thu, 24 Feb 2005 15:43:59 -0800
"Yulius Tjahjadi" <yu...@xf...> wrote:

> Hi,
>=20
> I have a couple of issues I'm trying to figure out.
>=20
> 1. We would like to handle a graceful database downtime by having php
> know
>    that our postgres database is down and display another page.  Right
> now,
>    0.36-pre2 stalls on sqlrcur_sendQuery if the database is shutdown.
> Is
>    there a way to not stall and figure out if sqlrelay is connected
>    from
> php?
>=20
> 2. On 0.36-pre2 if postgres runs out of connection, sqlrelay will
> crash.
>    To reproduce this, run postgres w/ 10 max connections, run sqlrelay
> with
>    a pool of greater than 10.  On startup, it will crash.  This is not
>    a big deal for me since we have a set pool size, but it might be an
> issue
>    for other people.
>=20
> yulius
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20