Thread: what is BIND in OS log for Postgresql

what is BIND in OS log for Postgresql

From
AI Rumman
Date:
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?

Thanks.

Re: what is BIND in OS log for Postgresql

From
Adrian Klaver
Date:
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.klaver@gmail.com