Jack Orenstein <jao(at)geophile(dot)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.
regards, tom lane