[Pgpool-general] Data not same on both nodes, streaming replication load balancing
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? Thanks. -- Armin ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] Data not same on both nodes, streaming replication load balancing
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 ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
Re: [Pgpool-general] Data not same on both nodes, streaming replication load balancing
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 ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
