2:06 p.m.
--------------------------------------------------------------------------------
Fedora Update Notification
FEDORA-2009-13750
2009-12-28 19:39:33
--------------------------------------------------------------------------------
Name : postgresql-pgpool-II
Product : Fedora 11
Version : 2.3.1
Release : 1.fc11
URL : http://pgpool.projects.PostgreSQL.org
Summary : Pgpool is a connection pooling/replication server for PostgreSQL
Description :
pgpool-II is a inherited project of pgpool (to classify from
pgpool-II, it is sometimes called as pgpool-I). For those of
you not familiar with pgpool-I, it is a multi-functional
middle ware for PostgreSQL that features connection pooling,
replication and load balancing functions. pgpool-I allows a
user to connect at most two PostgreSQL servers for higher
availability or for higher search performance compared to a
single PostgreSQL server.
pgpool-II, on the other hand, allows multiple PostgreSQL
servers (DB nodes) to be connected, which enables queries
to be executed simultaneously on all servers. In other words,
it enables "parallel query" processing. Also, pgpool-II can
be started as pgpool-I by changing configuration parameters.
pgpool-II that is executed in pgpool-I mode enables multiple
DB nodes to be connected, which was not possible in pgpool-I.
--------------------------------------------------------------------------------
Update Information:
Bugfix in init script: Adjust order of startup and kill, per RH bugzilla
#545739. 2.3 changelog: This version enhances replication, especially
CURRENT_TIMESTAMP, CURRENT_DATE, now() etc. now can be properly replicated.
Also perforance of replication when num_init_children == 1 is enhanced.
Pgpool-II now records the status of down nodes, and remembers when it restarts
to ensure that keep the node status as before. Also some logs are enhanced and
more fine fail over controls are added. 2.3.1 changelog: * Bug fixes -
If all of following conditions met, incorrect data is written to DB(Tatsuo) -
pgpool is running in replication mode - pgpool is running on 64bit OS - INSERT
or UPDATE are used which explicitly include now(), - CURRENT_TIMESTAMP,
CURRENT_DATE, CURRENT_TIME. Or the target - Table's default value use above
functions - The SQQL statement inclludes out of 32bit integer(-2147483648 to
2147483647 in decimal) Example SQL: INSERT INTO t1(id, regdate)
VALUES(98887776655, NOW()); - Fix crash in case of more than 18 DB nodes are
used(Tatsuo) - Enhance kind mismatch error message. If kind is ERROR or
NOTICE, the error or notice message from PostgreSQL will be printed(Tatsuo)
--------------------------------------------------------------------------------
ChangeLog:
* Fri Dec 25 2009 Devrim GUNDUZ <devrim(a)gunduz.org> - 2.3.1-1
- Update to 2.3.1
- Adjust order of startup and kill, per RH bugzilla #545739.
* Tue Dec 1 2009 Devrim GUNDUZ <devrim(a)gunduz.org> - 2.2.6-1
- Update to 2.2.6
* Sun Nov 1 2009 Devrim GUNDUZ <devrim(a)gunduz.org> - 2.2.5-2
- Remove init script from all runlevels before uninstall. Per RH Bugzilla
* Sun Oct 4 2009 Devrim Gunduz <devrim(a)CommandPrompt.com> 2.2.5-1
- Update to 2.2.5, for various fixes described at
http://lists.pgfoundry.org/pipermail/pgpool-general/2009-October/002188.html
* Sat Oct 3 2009 Devrim Gunduz <devrim(a)CommandPrompt.com> 2.2.4-1
- Update to 2.2.4
- Re-apply a fix for #442372
* Thu May 7 2009 Devrim Gunduz <devrim(a)CommandPrompt.com> 2.2.2-1
- Update to 2.2.2
--------------------------------------------------------------------------------
References:
[ 1 ] Bug #545739 - Should start after local postgresql
https://bugzilla.redhat.com/show_bug.cgi?id=545739
--------------------------------------------------------------------------------
This update can be installed with the "yum" update program. Use
su -c 'yum update postgresql-pgpool-II' at the command line.
For more information, refer to "Managing Software with yum",
available at http://docs.fedoraproject.org/yum/.
All packages are signed with the Fedora Project GPG key. More details on the
GPG keys used by the Fedora Project can be found at
http://fedoraproject.org/keys
--------------------------------------------------------------------------------