Re: what is BIND in OS log for Postgresql

On 10/14/2013 03:22 PM, AI Rumman wrote:
> Hi,
>
> I got in my OS log using ps command as follows:
>
> postgres 17087 2770 0 Sep30 ? 00:07:49 postgres: myapp appname
> 10.0.0.1(35607) BIND
> postgres 32545 2770 1 Oct01 ? 00:19:09 postgres: myapp appname
> 10.0.0.1(35783) SELECT
> postgres 32546 2770 1 Oct01 ? 00:15:25 postgres: myapp appname
> 10.0.0.1(35787) SELECT
>
> Could you please let me know why I got this BIND?

Are you using prepared statements or using some connection software that is?

http://www.postgresql.org/docs/9.3/static/protocol-flow.html

Once a prepared statement exists, it can be readied for execution using
a Bind message. The Bind message gives the name of the source prepared
statement (empty string denotes the unnamed prepared statement), the
name of the destination portal (empty string denotes the unnamed
portal), and the values to use for any parameter placeholders present in
the prepared statement. The supplied parameter set must match those
needed by the prepared statement. (If you declared any void parameters
in the Parse message, pass NULL values for them in the Bind message.)
Bind also specifies the format to use for any data returned by the
query; the format can be specified overall, or per-column. The response
is either BindComplete or ErrorResponse.

>
> Thanks.
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com