Re: Is there a way to abort a long COPY?

> database in my script. Is there a way to tell the server to abort the
> COPY?

Try bumping the logging level and see if your script is issuing a PQcancel 
or not. It may or may not be, depending on how rudely things got interrupted. 

Also keep in mind that long-running COPYs can take a while to "unwind". If 
you are just looking for a way to cancel a still-running COPY, check the output 
of pg_stat_activity and confirm it is running (and grab the PID), and then 
send it a pg_cancel_backend(PID).

-- 
Greg Sabino Mullane [email protected]
End Point Corporation
PGP Key: 0x14964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlPDOrUACgkQvJuQZxSWSshYFgCfeZWeq+gY6Nx7tmSQTPLR8Qze
CHwAoJUxEolvhJDJEhVUUhTMGEhyerq5
=7/05
-----END PGP SIGNATURE-----