Re: [GENERAL] [IDLE IN TRANSACTION] doing a remote pg_dump

2006-04-06 Thread Jim Nasby
On Apr 5, 2006, at 10:47 AM, Dick Wieland wrote: 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 Mac

[GENERAL] [IDLE IN TRANSACTION] doing a remote pg_dump

2006-04-05 Thread Dick Wieland
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 tran