Re: [Pgpool-general] The Unplugged wire

Thanks to you Tatsuo,... I am glad my report helped you! As soon as you tell me it is done I will start testing/debugging it again. 2010/3/2 Tatsuo Ishii is...@sraoss.co.jp Daniel, Thanks for the report! I spoke in another message about this problem, yet, I debugged deeper and I have

Re: [Pgpool-general] pgpool crashing(?) at startup

Sorry for delay. Toshihiro Kitagawa identified your problem was fixed in pgpool-II 2.2.4. Please upgrade. http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/main.c.diff?r1=1.49r2=1.50f=u -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:

[Pgpool-general] info

Hello all, Sorry if this might sound like a stupid question, but I am new to pgpool. Lets say I am running pgpool master and slave DB on all different servers. If the Master DB goes down, and I mean the whole server goes boom. Is there a way to automatically turn the slave into Master

Re: [Pgpool-general] Pgpool-general Digest, Vol 64, Issue 2

What happen if in heath check, a backend is ok, soon after health check, backend will unpluged ( so there is an error backend ). is there any query will failed ? No problem. Health checking is done by a separate process, i.e. pgpool parent. So even if pgpool children are blocked by

Re: [Pgpool-general] Pgpool with many inserts and updates

I've just finished reading http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html and http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html but I'm still very new pgpool so please be patient. Just looking for some pointers to steer me in the right direction.

Re: [Pgpool-general] The Unplugged wire

Daniel, I have committed fix into CVS HEAD. Could you try it out? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp Thanks to you Tatsuo,... I am glad my report helped you! As soon as you tell me it is done I will start

Re: [Pgpool-general] Pgpool with many inserts and updates

Tatsuo, Pgpool-II does not enhance write performance of PostgreSQL. You will get write performance of roughly 60-70% of PostgreSQL when pgpool-II is running in repication mode. With master/slave mode + Slony-I you could obtain better than it, still it is slightly lower than 100%. So first

Re: [Pgpool-general] Pgpool-general Digest, Vol 64, Issue 5

What happen if in heath check, a backend is ok, soon after health check, backend will unpluged ( so there is an error backend ). is there any query will failed ? No problem. Health checking is done by a separate process, i.e. pgpool parent.  So even if pgpool children are blocked by

Re: [Pgpool-general] Pgpool-general Digest, Vol 64, Issue 5

What happen if in heath check, a backend is ok, soon after health check, backend will unpluged ( so there is an error backend ). is there any query will failed ? No problem. Health checking is done by a separate process, i.e. pgpool parent.  So even if pgpool children are blocked by

Re: [Pgpool-general] Pgpool with many inserts and updates

On Wed, Mar 3, 2010 at 2:15 AM, Josh Berkus j...@agliodbs.com wrote: Pgpool-II does not enhance write performance of PostgreSQL.  You will get write performance of roughly 60-70% of PostgreSQL when pgpool-II is running in repication mode. With master/slave mode + Slony-I you could obtain