Re: Can't terminate hung COPY

2013/3/20 David Rees <drees76(at)gmail(dot)com>:
> PostgreSQL 8.4.16 on CentOS 5.9.
>
> I've run into a situation where executing a \COPY from psql will hang
> and at that point it's impossible to terminate the COPY command.
>
> I've tried pg_cancel_backend and pg_terminalte_backend - even sending
> the process itself a TERM signal.
>
> Sending the process KILL works, but of course that restarts the entire
> server which is far from ideal.
>
> Any idea on how to cleanly terminal the offending process at this point?
>
> Any idea on what may cause \COPY to hang and how to prevent it?

What happens if you use COPY ... FROM with the same data?

Are you sure the process hangs (strange thing is that you can't
terminate the backend)? Could it be that it looks like it hung, but
it's actually COPYing a huge chunk of data?

--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador