Re: Postgres connection status as BIND

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres connection status as BIND
Date: 2009-06-15 15:08:01
Message-ID: 200906150808.01841@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Monday 15 June 2009, Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com> wrote:
> 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.

pgpool does that on some connections on some of my servers (but not others).
I haven't been able to figure out why.

--
WARNING: Do not look into laser with remaining eye.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alberto Dalmaso 2009-06-16 13:37:42 performance with query
Previous Message Tom Lane 2009-06-15 14:17:23 Re: Postgres connection status as BIND