Re: Why is psql \copy process stuck?

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