[Pgcluster-general] SELECT is executed on all nodes if withing transaction

[Christian Dannemann]

Hi Alexey,

put

not_replicate_prepared_select = true

in postgresql.conf on all cluster servers and the problem is resolved.

Cheers,

Christian


Alexey Kamenchuk wrote:
>
> Hi All
>
>  
>
> I mentioned that load balancer executes SELECT on all nodes if it is 
> issued within transaction. I expected the behavior when SELECT is sent 
> to only DB node. Is it something wrong with my configuration or this 
> is how LB always works?
>
>  
>
> Thanks
>
>  
>
> Best regards
>
> Alexey Kamenchuk
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070219/ffa1b51f/attachment.html