Re: [Pgpool-general] Pgpool I vs Pgpool II

2011-09-22 Thread Toshihiro Kitagawa
Hi Glyn, takizo, I created a patch to fix a massive memory leak of raw mode. The patch which was posted before by Yoshiyuki seems correct. However, I think it's better to call pool_query_context_destroy() than free_parser(). Would you try an attached patch? The patch is for V3.0_STABLE branch,

Re: [Pgpool-general] Pgpool I vs Pgpool II

2011-09-22 Thread Tatsuo Ishii
One comment. According to Toshihiro, the memory leak only occurs in raw mode. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Hi Glyn, takizo, I created a patch to fix a massive memory leak of raw mode. The patch which was

[Pgpool-general] Replicate selected table

2011-09-22 Thread Micka
Hello, I've two server : A B. In the Server A, I've the table 1 and 3 In the Server B, I've the table 2 and 4. I would like to know if the server A can replicate the table 1 and 3 to the server B. And the server B can replicate the table 2 and 4 to the server A ? Thank you,

[Pgpool-general] pgpool segfaulting and dumping core

2011-09-22 Thread Lonni J Friedman
Greetings, I'm running pgpool-II-3.0.4 on a Linux-x86_64 server, which is load balancing for a cluster of 3 PostgreSQL-9.0.4 servers (1 master, 2 standby). I'm using pgpool for load balancing only (not managing streaming replication or failover). Last night, pgpool started segfaulting

Re: [Pgpool-general] pgpool segfaulting and dumping core

2011-09-22 Thread Tatsuo Ishii
Greetings, I'm running pgpool-II-3.0.4 on a Linux-x86_64 server, which is load balancing for a cluster of 3 PostgreSQL-9.0.4 servers (1 master, 2 standby). I'm using pgpool for load balancing only (not managing streaming replication or failover). Last night, pgpool started segfaulting

Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave mode?

2011-09-22 Thread Josh Berkus
- cluster directory of new Master (5433) contains recovery.done This is correct. - postgresql.conf of new Master (5433) still contains hot_standby = on. This is correct. Now, I want to bring up the original Master (5432) as a new Standby. Hence, I create basebackup and

Re: [Pgpool-general] Replicate selected table

2011-09-22 Thread Daniel . Crespo
So in the end, Server A and B are meant to be identical, right? If so, you need multi-master replication. I think Bucardo is the one that can do that. -Daniel From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-boun...@pgfoundry.org] On Behalf Of Micka Sent: Thursday,

Re: [Pgpool-general] pgpool segfaulting and dumping core

2011-09-22 Thread Tatsuo Ishii
I checked a second of the coredumps, and it has the same backtrace. Let me know if you need anything else. thanks! Thanks. Can you show me pgpool log when DNS failed and pgpool died in segfaulting? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: