[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