When we do a ps U postgres command, we find some connection in BIND status:
10088 ? Ss 0:00 postgres: chk production xxx.xx.x.xx(48672) BIND 10090 ? Ss 0:00 postgres: chk production xxx.xx.x.xx(48674) BIND
We are connecting to the database using pgpool for load balancing and slony for replication. Postgres version - 8.3.3.
The queries running over this connections appear to be hanged and are not running.
Can anybody tell what exactly the above connection status means, and how we can get rid of this connections, pg_cancel_backend doesn't seem to help here?