From: | "Maksym Boguk" <Maxim(dot)Boguk(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend |
Date: | 2011-07-02 04:42:36 |
Message-ID: | 201107020442.p624gahY078103@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6088
Logged by: Maksym Boguk
Email address: Maxim(dot)Boguk(at)gmail(dot)com
PostgreSQL version: 8.4.7
Operating system: Freebsd
Description: copy to stdout cannot be stopped with kill(pid) or
pg_terminate_backend
Details:
Again I not sure it is actual bug or intended behaviour.
But I found I can not stop
COPY bill.changes (id, cdate, mdate, status, table_name, pk_id, old_row,
new_row) TO stdout;
with pg_terminate_backend(procpid) or kill (procpid).
At the same time copy to stdout completely ignore fact other side (pg_dump
itself) was killed long time ago.
That is can be problem because backup of some huge table can be very long
process and prevent any DDL changes for all tables in the that database
(because pg_dump keep lock on all tables).
Now I'm sitting with open ssh and waiting 2 hour while that 120Gb table
finally finish copying and I can perform some urgent DDL on the database.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-07-02 04:53:42 | Re: BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend |
Previous Message | Tom Lane | 2011-07-02 03:35:21 | Re: BUG #6080: information_schema.columns.column_default contains NULL inconsistently |