[Pgpool-general] Data not same on both nodes, streaming replication & load balancing

[Tatsuo Ishii]

Pgpool-II is not responsible for replication itself when operated with
streaming replication. Are you sure that streaming replicaton is
working? If so, you'd better to send questions to postgresql-general.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I have configuration pgpool streaming replication & load balancing
> configuration with two nodes.
> 
> pgpool version is 3.1.0-alpha2 (hatsuiboshi), postgres on both nodes is
> 9.0.4
> 
>  
> 
> Reason why I have use this version is that latest stable version (at
> that time) 3.0.1 was everything
> 
> but not stable.
> 
>  
> 
> Anyway.. I have situation now.. that my slave node is containing
> different data from master node.
> 
> I select something from master and get one result, and same query from
> slave and I get different result.
> 
>  
> 
> How to prevent this happening, and how it is possible that this
> happened.
> 
> How to know data my other data is health?
> 
>  
> 
> This is specific to PostgreSQL 9.x Streaming Replication. Please check:
> http://www.postgresql.org/docs/9.0/interactive/warm-standby.html#STREAMI
> NG-REPLICATION
> 
>  
> 
> -Daniel
>