Postgres connection status as BIND

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Postgres connection status as BIND
Date: 2009-06-15 09:30:15
Message-ID: 965aa3ed0906150230o6b937294of11cb97d00272de6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-06-15 14:17:23 Re: Postgres connection status as BIND
Previous Message Dan Langille 2009-06-13 22:36:43 Re: Censorship