Tom Lane wrote:
> Jack Orenstein <jao@geophile.com> 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