Path to this page:
Subject: CVS commit: wip/pgpool2
From: Filip Hajny
Date: 2015-04-13 21:59:59
Message id: E1YhkWm-00074d-QW@sfs-ml-1.v29.ch3.sourceforge.com
Log Message:
Update pgpool2 to 3.4.2. Add SMF support.
3.4.2
* Bugfixes
3.4.1
* Bugfixes
3.4.0
New major version up from 3.3.
* Incompatible changes
- Parallel query mode is obsoleted and is removed from
pgpool.conf. This is due to the very few users using the mode
(and the relatively high cost to maintain it). Actual codes for
the mode are still there and users can use the mode if they
specify necessary parameters in pgpool.conf. Note, however, the
next version of pgpool-II (will be 3.5.0) will actually remove
the code.
- "print_timestamp" parameter is removed. Instead new
"log_line_prefix" should be used.
- Recovery script now accepts 4 parameters, rather than 3 (the 4th
parameter is the port number of master PostgreSQL). Existing
3-parameter-style recovery scripts can be used if you don't care
about information provided by the 4th parameter.
* New features
- Allow fine control of load balancing by using application name
or database name. For example, if a client has particular
application name, read queries can be redirect to master node,
rather than to one of slave nodes (Tatsuo Ishii)
- Allow to print pgpool-II process names in the log output. New
parameter "log_line_prefix", which is the printf-style string
that is output at the beginning of each log line (Muhammad Usama)
- Allow to control log verbosity like PostgreSQL. For this purpose
new parameters "log_error_verbosity", \
"client_min_messages",
"log_min_messages" are added (Muhammad Usama)
- Allow to use SQL comments without disturbing load balancing if
new parameter "allow_sql_comments" is on. If it's off, previous
behavior is kept (Tatsuo Ishii)
- Allow to skip unlogged tables checking by using new parameter
"check_unlogged_table". This reduces the number of pgpool-II's
internal catalog look up queries and enhances performance
(Tatsuo Ishii)
- Prevent listen backlog overflow by using new parameter
"listen_backlog_multiplier" for very busy systems (Tatsuo Ishii)
- Prevent connection timeout to backend by using new parameter
"connect_timeout". This is useful in unstable networks
(Tatsuo Ishii)
* Enhancements
- Builtin SQL parser is now compatible with PostgreSQL 9.4 (Muhammad Usama)
- Import PostgreSQL's memory manager and exception manager (Muhammad Usama)
- Reorganize source code tree (Muhammad Usama)
- The status file "pgpool_status" is now a plain ASCII file. This
allows to register down PostgreSQL nodes before pgpool-II
starts for example (Tatsuo Ishii)
- Allow to use IPv6 address for PostgreSQ (Michael Stapelberg)
- Allow to use IPv6 bind address for pgpool-II (Michael Stapelberg)
- Rename all occurrence of "on memory query cache" to "in memory
query cache" because latter is more correct in English (Tatsuo Ishii)
Files: