[pgpool-general: 643] Replication/Load balancing not working as expected

Theodotos Andreou theo at ubuntucy.org
Sun Jun 17 16:49:22 JST 2012


Hi all,

I am a newbie to pgpool-II. I want to use replication/load-balancing and 
I use the latest pgpoll-II (3.1.3) compiled from source. I have two 
postgresql nodes (node1, node2) and a loadbalancer (loadb) all on the 
same subnet.

I can connect from the load balancer to the backends using the command 
"psql -h node1" and "psql -h node2". So no network issues here:

I am using this config:

http://pastebin.com/EnVKgLD4

But when I use the "createdb testing" command on load balancer the 
database is created on node1 only. Is this normal with this setup? 
Replication does not imply that all write commands are propagated to 
both backends?

Load balancing also appers to work correctly because when using twice 
the "psql" command on load balancer it first opens a session with node1 
and then again on node1. On all my tests I get no postgres traffic to my 
second node.

Is this expected? Is my config wrong or the way I test? Ideas?

Regards
Theo


More information about the pgpool-general mailing list