PostgreSQL – Terminate active connections

Tested On

PostgreSQL 10.5

Terminate active connections

procid refers to the pid field from the pg_stat_activity table.

We can also terminate active connections belonging to a particular user. For example,

Karl San Gabriel

Karl San Gabriel

Java and Enterprise Technologies Expert