> 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 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
