| From: | Jack Orenstein <jorenstein(at)archivas(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jack Orenstein <jao(at)geophile(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why is psql \copy process stuck? |
| Date: | 2005-05-14 16:53:16 |
| Message-ID: | 42862CFC.5040200@archivas.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-05-14 18:15:41 | Re: Why is psql \copy process stuck? |
| Previous Message | Tom Lane | 2005-05-14 16:40:38 | Re: Why is psql \copy process stuck? |