5:24 p.m.
--------------------------------------------------------------------------------
Fedora EPEL Update Notification
FEDORA-EPEL-2009-1078
2009-12-31 06:21:54
--------------------------------------------------------------------------------
Name : postgresql-pgpool-II
Product : Fedora EPEL 4
Version : 2.3.1
Release : 1.el4
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)
--------------------------------------------------------------------------------
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 programs. 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 EPEL GPG key. More details on the
GPG keys used by the Fedora Project can be found at
https://fedoraproject.org/keys
--------------------------------------------------------------------------------