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.
João Cosme de Oliveira Júnior
Seja inteligente, use Software-livre!!!
LPI Certified
LPI000185554
"Esta mensagem do SERVIÇO FEDERAL DE PROCESSAMENTO DE DADOS (SERPRO), empresa pública federal regida pelo disposto na Lei Federal nº 5.615, é enviada exclusivamente a seu destinatário e pode conter informações confidenciais, protegidas por sigilo profissional. Sua utilização desautorizada é ilegal e sujeita o infrator às penas da lei. Se você a recebeu indevidamente, queira, por gentileza, reenviá-la ao emitente, esclarecendo o equívoco." "This message from SERVIÇO FEDERAL DE PROCESSAMENTO DE DADOS (SERPRO) -- a government company established under Brazilian law (5.615/70) -- is directed exclusively to its addressee and may contain confidential data, protected under professional secrecy rules. Its unauthorized use is illegal and may subject the transgressor to the law's penalties. If you're not the addressee, please send it back, elucidating the failure." |
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
