pgpool-II/pgpoolAdmin 3.1.1 released

pgpool Global Development Group is pleased to announce the availability
of pgpool-II 3.1.1, the latest stable version of pgpool-II 3.1 series.
And we also released pgpoolAdmin 3.1.1.

You can download the source codes from:

http://www.pgpool.net/download.php?f=pgpool-II-3.1.1.tar.gz
http://www.pgpool.net/download.php?f=pgpoolAdmin-3.1.1.tar.gz

[Note: pgpool development is now hosted at new community site:
http://www.pgpool.net (moved from pgfoundry). Downloading, mailing
list and other services are available at the site.]

=========================================================================
pgpool-II 3.1.1
=========================================================================

This is a bugfix release against pgpool-II 3.1.

-------------------------------------------------------------------------
* Bug fixes
-------------------------------------------------------------------------

- Fix add_regex_pattern(). It does not allocate enough memory for each
black/white_function_list items. The function adds "^" and "$" to each
function items which do not contain those characters. Unfortunately the
function forgot to add extra 2 bytes for those characters. This may lead
to memory corruption errors when pgpool starting up.

- Fix error message of check_replication_time_lag(Tatsuo Ishii).
It emitted wrong error message when it failed to connect to PostgreSQL
while checking streaming replication delay. Because it does not use
health_check_user anymore.

- Fix memory leak(Toshihiro Kitagawa).
This is essentially same as the fix made for 3.0.5(commit
19a4ea9215da0b61728741fc0da2271958b09238).

- Major cleanup for strncpy(Tatsuo Ishii).
There are several places where strncpy() is used. Problem is some of
them do not consider the case when copy lengh == buffer size. In this
case copied buffer is not null terminated and may cause tons of problems
later. To fix this, most of them are replaced by strlcpy().

- Update cached backend status whenever possible(Tatsuo Ishii).
This solves the problem of follow_master_command not being able to
lookup backend status correctly which was reported by Jeff Frost:

Subject: [Pgpool-general] diagnosing BackendError from pcp_recovery_node
To: pgpool-general(at)pgfoundry(dot)org
Date: Wed, 05 Oct 2011 15:15:07 -0700

- Fix buffer overrun problem when pcp password is longer than 32(Tatsuo
Ishii).

- Remove PGDLLIMPORTI which is only neccessary for Windows and cause a
problem for non gcc. Patch contributed by Ibrar Ahmed.

=========================================================================
pgpoolAdmin 3.1.1
=========================================================================

-------------------------------------------------------------------------
* Bug fixes
-------------------------------------------------------------------------

- Fix not to ignore changing boolean values in pgpool.conf.(Nozomi Anzai)
- Fix not to ignore changing D option of pgpool command in pgmgt.conf.
(Nozomi Anzai)
- At query cache page it somtimes happens "redeclare function" error,
so replace include() to require_once().(Nozomi Anzai)

-------------------------------------------------------------------------
* Enhancements
-------------------------------------------------------------------------

- Update french document.(Guillaume Lelarge)

=========================================================================
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp