Tom Lane wrote:
1Heikki Linnakangas <[EMAIL PROTECTED]> writes:
Peter Koczan wrote:
There is a problem where connections listening for asynchronous notifies
occasionally block for writing on ther server side and never finish,
Does the client read the async notifies? The write in the server will
block if the client doesn't keep up with reading the data.
Loss of network connectivity to the client (eg, timeout of a NAT
mapping) seems like another plausible explanation.
regards, tom lane
It's plausible, but unlikely for our network setup. We rarely use NAT
and if the client lost its network, this particular application (it's
Perl with GTK and DBD::Pg, by the way) tends to hang since it doesn't
try to re-establish a connection to the DB short of killing and
restarting it.
Peter
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly