Jack Orenstein <jao@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly