On Tue, Jul 30, 2013 at 10:29 AM, Leonardo M. Ramé <l.r...@griensu.com>wrote:
> > > select pg_cancel_backend(pid) from pg_stat_activity where pid <> > > > pg_backend_pid(); > As Giuseppe mentioned, if you need to kill not just the queries, but the connection as well, you could use: select pg_terminate_backend(pid) from pg_stat_activity where pid <> pg_backend_pid(); That is much safer than kill -9, which if issued against the parent postgres process will crash your cluster. > > Sorry bricklen, I've killed all idle connections with "kill -9 <PID>", > then I was able to execute the alter table. > No problem.
