Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
21167 ? S 0:00 /usr/local/pgsql/bin/psql -h 10.3.1.154 mydb -U username -c \copy sometable to stdout
Why is process 21167 stuck?
Are you sure it's made a connection at all? You might try attaching to
it with a debugger to get a stack trace. Also, see if you can identify
a connected backend on the remote machine, and gdb that to see what it
is doing.
As far as I can tell there is no process corresponding to the copy
on the remote node. I checked ps and looked at pg_locks.
I'll work on attaching to the local copy processes.
Jack Orenstein
---------------------------(end of broadcast)---------------------------
TIP 3: 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
