Hello,
I'm running pgsql 8.1.3 and ran into an unexpected situation running
pg_dump remotely. We have 2 LAN's situated some distance apart. I can
run pg_dump against machine A on LAN1 from machine B on LAN1 with no
problem. But if I try to run it from Machine C on LAN2 it stalls with
"idle in transaction" on the server.
I've seen some snippets of commentary on timeouts, etc. and have a
feeling I'm running into the same problem, but I can't tell whether
there is a solution or not. Can someone please point out a place where I
can read up on this situation in more detail so I can understand the
issues better?
Thanks,
Dick Wieland
--
Dick Wieland
WiLine Networks Inc.
University Park Plaza
741 Alexander Road
Suite 8
Princeton, NJ 08540-6301
voice:609 720 9448 x3002
fax: 609 720 9447
dick.wieland@wiline.com