[Pgpool-general] PGPOOL II behavior

[Tatsuo Ishii]

> I have pgpool 2 working on replication and loadbalance mode.
> I would like to just  undestand this kind of behavior.
> i have one node as a pooler and other 2 nodes as postgresql backends.
> 
> I connected on pool and everthing was fine... i saw on the backend logs that queries were
> balanced.
> I saw on pgpool logs that every time that any  connection was made  on the pool , the pool
> made a  connecting  on both  nodes.
> 
> 2009-10-19 14:52:14 DEBUG: pid 1513: new_connection: connecting 0 backend
> 2009-10-19 14:52:14 DEBUG: pid 1513: new_connection: connecting 1 backend
> 
> I saw too on backend logs that connection were opened.
> 
> Why do pool need to connect on all  nodes on any connection? Did the pool connect on all
> node at same time? i  thought that the the connection where balanced too.

Possible causes are:

- database is one of template0, template1, postgres or regression

- max_pool is not sufficient

- connection_cache is false
--
Tatsuo Ishii
SRA OSS, Inc. Japan