New versions of PgPool released - 3.1.3 & 3.0.7
This essential tool for Postgres architectures is continually improving, and is now available in its new releases. Both are bugfix versions.
For those unfamiliar with the tool, it is a middleware with functionality as a load balancer, pooler* and/or replication system for PostgreSQL databases. The 3.1.x versions are compatible with Postgres 9.x, whose streaming replication feature was pushed to Pgpool developers to take advantage of it. This allows the tool to balance queries without using the pgpool-replication technique.
In the 3.1.3/3.0.7 fixes we have:
- Allow multi statement transactions in master/slave mode: Transactions with BEGIN, since 3.1 were sent to the slaves/standby servers as well. This brings non desirable effects when the transaction contains DELETE/INSERT/UPDATE, due to the fact that standbys cannot execute writable SQL. (3.1.3 fix)
- Important fixes for failover detection and execution. (3.1.3 fix)
- Added m4 files to avoid problems when compiling in older operating systems.
- Fixed hangup on PREPARE errors.
- Fixed memory leak in reset queries.
If you are running 3.1.x against Postgres 9 databases, we strongly recommend you upgrade PgPool due to the fixing in the multi statement feature.
For more information http://www.pgpool.net/mediawiki/index.php/Main_Page
* If you need only a connection pooler for Postgres, I prefer PgBouncer http://wiki.postgresql.org/wiki/PgBouncer. It is lightweight and more specific and simply works, without as much configuration.
Archives
- May 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- November 2009
- March 2008
- November 2007
- October 2007


Comments
Reply