Hi,
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?
Let me know I can provide some more info.
Regards,
Nimesh.