ALTER COLUMN on table with access lock

Question

I'm trying to alter a table column in Postgres, but the table has several AccessShare and AccessExclusive locks. How do I over come the locks?

Answer 1

Kick out the connections that cause the locks. Use pg_cancel_backend() or even pg_terminate_backend().

http://www.postgresql.org/docs/current/static/functions-admin.html