Hello,
I have a perl script that is giving me fits.
The basic system accesses postgres across a network. I am trying to code
for things like network failures, etc., basically if the backend is not
available or ready I need to process locally and in a hurry, so any delay
is not acceptable.
I am using the Pg module right now, I have looked at DBI, but would prefer
to use the Pg for now.
I am simulating the network failure by pulling the plug on the nic (worst
case scenario...:) )
$conn->status returns connection good after this (?), doing a $conn->reset
sends me into never-never land for a couple of minutes ( I assume this is
a timeout somewhere, is it adjustable at the frontend at runtime?)
I finally worked around that by using alarm(), but after getting to where
$conn->status does return CONNECTION_BAD, I have so far been unable to
reconnect to the backend!
Is there something I am missing? There has got to be a better way to do
what I need.
Any pointers appreciated!
Bill Carlson | Opinions expressed are my own
KINZE Manufacturing, Inc. | not my employer's.