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

Mon Jun 18 17:02:24 JST 2012

Thanks Lazaro,

The problem turn out to be a misconfiguration in the second backend's 
data directory. After correcting it, all is fine.

Thanks guys.

On 06/18/2012 03:37 AM, Lazáro Rubén García Martínez wrote:
> Set this properties in your pgpool configuration file, and run pgpool in debug mode (-d option)
>
> log_destination = 'stderr'
> print_timestamp = on
> log_connections = on
> log_hostname = on
> log_statement = on
> log_per_node_statement = on
>
> With this properties you can see the queries sent to each node, and what is realy happen.
>
> Opss!!!
>
> I think you are connecting to the database directly, because you are using only these parameters "psql -h node2"
>
> Are you connecting to postgresql through pgpool like this:
>
> psql -U database_user -h ip_pgpool_host -p pgpool_port -d database_name ?
>
> The efects of the load balancing funtion take place when there are many users connecting to pgpool concurrently.
>
> I recomend you reading the pgpool FAQ page, in it there is a topic related with your load balancing question.
>
> Regards.
> ________________________________________
> From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Theodotos Andreou [theo at ubuntucy.org]
> Sent: Sunday, June 17, 2012 3:19 AM
> To: pgpool-general at pgpool.net
> Subject: [pgpool-general: 643] Replication/Load balancing not working as        expected
>
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com

<html>
<body>
<img src="http://new.cut.ac.cy/images/environmentalSign.gif"/>
</body>
</html>