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

[Daniel.Crespo at l-3com.com]

Hi everyone,

 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110920/310b94ab/attachment.html>