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

2011-09-20 Thread Armin Nesiren
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

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

2011-09-20 Thread Daniel . Crespo
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

Re: [Pgpool-general] seemingly hung pgpool process consuming 100% CPU

2011-09-20 Thread Lonni J Friedman
I tried to do that, but pgpool refuses to start reporting: -bash: /usr/lib/debug/usr/sbin/pgpool.debug: bad ELF interpreter: No such file or directory I'm puzzled why it fails, as it was built on the same server where I built the (working) release build of pgpool. $ file

Re: [Pgpool-general] Pgpool-II connection problems when monitoring Heartbeat

2011-09-20 Thread Maria Antonia Lajus Marrero
Hello, I need anyone help me!!! I'm pretty new working with cluster tools. I've a 4 node scheme to ensure high availability, replication, connection pooling and load balancing, 2 nodes are balancers and 2 are SQL(backends). Each balancer has an instance of pgPool-II 3.0.3 and Heartbeat 2.1.3. the

Re: [Pgpool-general] Pgpool-II connection problems when monitoring Heartbeat

2011-09-20 Thread Tatsuo Ishii
Please provide logging of pgpool and PostgreSQL when the problem occured. In the mean time, I don't see particular problem with PostgreSQL 8.3.9 and pgpool-II 3.0.3 combo. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hello,

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

2011-09-20 Thread 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: