./databases/pgpool2, Middleware between PostgreSQL servers and a PostgreSQL database client

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 3.6.5, Package name: postgresql92-pgpool2-3.6.5, Maintainer: filip

pgpool-II is a middleware that works between PostgreSQL
servers and a PostgreSQL database client. It talks
PostgreSQL's backend and frontend protocol, and relays
a connection between them.

Required to run:

Master sites:

SHA1: 573e5f80691330632ed23648a24c502221175a31
RMD160: 83b2e8f86bcb7b3fceb57ed6ef485181b43325f9
Filesize: 2589.189 KB

Version history: (Expand)

CVS history: (Expand)

   2017-08-17 09:46:05 by Filip Hajny | Files touched by this commit (4) | Package updated
Log message:
Update databases/pgpool2 to 3.6.5, based on patches by Mustafa Dogan.
Fixes pkg/52488.

Release 3.6.5
- Fix for [pgpool-hackers: 2400] Garbage output
- Importing the latest changes in the MemoryManager API from PostgreSQL
- Fixing 0000306: Pgpool steals back MASTER status.
- Fixing [pgpool-hackers: 2390]Problems with the relative paths in
  daemon mode
- Adjust function name change in PostgreSQL 10 dev head.
- Fix a posible hang with streaming replication and extended protocol.
- Fix Pgpool-II hang when used by erlang applications.
- Fix bug with sending bind message to wrong target node.
- Fix query cache hang when used by node.js.
- Deal with PostgreSQL 10 in streaming replication delay checking.
- Fix query cache memory leak.
- Fix extended query hang in certain case.
- Fix for [pgpool-hackers: 2354] segfault with pg_md5.
- Fix descriptions of white/black_memcache_table_list.
- Fix corner case bug in Pgpool-II starting up.

Release 3.6.4
- Fixing a few corner cases in the failover request handling of the
- Tightening up the watchdog cluster membership criteria.
- Enhance document for load balancing.
- Add node 0 failover test.
- Fix Pgpool-II child process segfault reported in [pgpool-hackers:

Release 3.6.3
- Fix "show pool_cache" segfault when memcached is used.
- Fix for some more code warnings.
- Fixing some annoying compiler warnings.
- Removing the function defined but not used warnings from
- Removing the references of obsolete debug_level configuration
- Fixing a mistake in the watchdog code.
- Fix for 0000299: Errors on the reloading of configuration.
- Add pgpool_adm English and Japanese docs.
- Fix document indentation.
- Fix for 0000289: Inconsistent backend state.
- Enhancing the handling of split-brain scenario by the watchdog.
- Enhancing the watchdog internal command mechanism to handle multiple
  concurrent commands.
- Fix compiler warnings.
- Comment out unsupported Java method in new JDBC drivers to prevent
  regression failure.
- Downgrade parse before bind log message to debug1.
- Fix coverity warnings.
- Fix for [pgpool-general: 5396] pam ldap failure.
- Mention that SQL type commands cannot be used in extended query mode.
- Consider SHOW command as kind of a read query.
- Fix memory leak problem caused by commit adcb636.
- Mega patch to fix "kind mismatch" (or derived) errors in streaming
  replication mode.
- Fix for 0000296: PGPool v3.6.2 terminated by systemd because the
  service Type has been set to 'forking'.

Release 3.6.2
- Add "Wants=network.target" to pgpool.service file.
- Fix pcp_promote_node bug that fails promoting node 0.
- Fix document error.
- Pgpool-IIshould not perform ping test after bringing down the VIP.
- Fix to release shared memory segments when Pgpool-IIexits.
- Fix for [pgpool-general: 5315] pg_terminate_backend
- Adding the missing ExecStop and ExecReload commands to the systemd
  service configuration file.
- Fix for 281: "segmentation fault" when execute pcp_attach_node.
- Fix load balancing bug in streaming replication mode.
- Fix yet another kind mismatch error in streaming replication mode.
- Fix do_query()hangs after close message.
- Fixing stack smashing detected.
- Fixing the issue with the watchdog process restart.
- Fix query cache bug reported in pgpool-general-jp:1441.
- Remove elog/ereport calls from signal handlers.
- Fix bug failed to create INET domain socket in FreeBSD if
  listen_addresses = '*'.
- Fix for 0000249: watchdog sometimes fails de-escalation.
- Fix connection_life_time broken by authentication_timeout.
- Fix authentication timeout that can occur right after client

Release 3.6.1
- Tightening up the watchdog security.
- Add pgpool_adm extension in Pgpool-II RPM.
- Fix occasional segfault when query cache is enabled.
- Fix packet kind does not match error in extended protocol.
- Fix a race condition in a signal handler.
- Fix wrong minimum configuration value for
- Allow to execute "make xslthtml" under doc.ja.
   2016-11-24 13:52:47 by Filip Hajny | Files touched by this commit (4) | Package updated
Log message:
Update databases/pgpool2 to 3.6.0.


Notable new features

- Improve the behavior of fail-over.
- New PGPOOL SET command has been introduced.
- Watchdog is significantly enhanced.
- Handling of extended query protocol (e.g. used by Java applications)
  in streaming replication mode speeds up if many rows are returned
  in a result set.
- Import parser of PostgreSQL 9.6.
- In some cases pg_terminate_backend() now does not trigger a fail-over.
- Change documentation format from raw HTML to SGML.


Bug fixes

- Fix buffer over run problem in "show pool_nodes".
- Fix usage of wait(2) in pgpool main process.
- Save and restore errno in each signal handler.
- Fix handling of pcp_listen_addresses config parameter.
- Fix "kind mismatch" error message in pgpool.
- Replace "MAJOR" macro to prevent occasional failure.
- Fixing a coding mistake in watchdog code.
- doc : Fixing a typo in english doc
- Fix for bun 215 that pgpool doesn't escalate ip in case of another node
- Fix for bug of inconsistent status of Postgresql nodes in Pgpool instances
  after restart.
- SIGUSR1 signal handler should be installed before watchdog initialization.
- Fix for bug 228 that pgpool doesn't de-escalate IP in case network
- Fix hang when portal suspend received.
- test : Add regression test for bug 230.
- Fixing a typo in the log message.
- Fixing the error messages when the socket operation fails.
- Tighten up health check timer expired condition in pool_check_fd().
- doc : Add comment to the document about connection_cache.
- Fix Handling of pcp_socket_dir was missing from pool_get_config().
- doc : Fix Japanese document typo.
- Fix "out of memory" by using "pg_md5 -m".
- Fix for 237 that Pgpool-II fails to start if listen_addresses is empty


New features

- Allow to access to pgpool while doing health checking

Bug fixes

- Fix is_set_transaction_serializable() when
  SET default_transaction_isolation TO 'serializable'.
- Fix Chinese documetation bug about raw mode
- Fix confusing comments in pgpool.conf
- Fix extended protocol handling in raw mode
- Permit pgpool to support multiple SSL cipher protocols
- If statement timeout is enabled on backend and do_query() sends a
  query to primary node, and all of following user queries are sent to
  standby, it is possible that the next command, for example END, could
  cause a statement timeout error on the primary, and a kind mismatch
  error on pgpool-II is raised.
- Deal with the case when the primary is not node 0 in streaming replication
- Fix a posible hang during health checking
- change the Makefile under this directory src/sql/,that is proposed by
- fix for 0000197: pgpool hangs connections to database..
- Fix bug with load balance node id info on shmem
- Fixing coverity scan reported issues.



- Fix for segfault during trusted_servers check
- Removing the limit on the maximum number of items in the
  black_function_list and white_function_list lists
- Fix check "PCP Directory" in "Parameter Setting" in install
- Fix extended protocol hang with empty query
- Redirect all user queries to primary server
- Change the PID length of pcp_proc_count command result to 6 characters



- Add some warning messages for wd_authkey hash calculation failure
- test: Fix regression test to check timeout of each test
- test: Allow timeout value to be specified by the command option
- Fix compile issue on FreeBSD
- test: Fix test/regression/clean.sh to remove binary files of
  010.rewrite_timestamp test
- Fix memorry leak reported by Coverity (CID 1350095)
- Fixing pgpool-recovery module compilation issue with PostgreSQL 9.6
- Fix to properly process an empty query that has only comments
- Fix a reset query stuck problem
- Fix a reset query stuck problem
- Fix query stuck problems in streaming replication mode with extended
  protocol queries
- Fix pgpool hung after receiving error state from backend
- Fix bug that child processes exit and are not re-spawned
- Fix typo in configure
- doc: Change description of backend_flag
- doc: Fix installation procedure.
- test: Fix pgpool_setup to not confuse log output
- Fix to validate the PCP packet length
   2016-10-09 23:42:04 by Thomas Klausner | Files touched by this commit (110)
Log message:
Recursive bump for all users of pgsql now that the default is 95.
   2016-06-08 12:16:57 by Jonathan Perkin | Files touched by this commit (89)
Log message:
Remove the stability entity, it has no meaning outside of an official context.
   2016-06-08 11:46:05 by Jonathan Perkin | Files touched by this commit (47)
Log message:
Change the service_bundle name to "export" to reduce diffs between the
original manifest.xml file and the output from "svccfg export".
   2016-03-11 22:30:55 by Filip Hajny | Files touched by this commit (11)
Log message:
Import pgpool-II 3.5.0 as databases/pgpool2, based on wip/pgpool2.

pgpool-II is a middleware that works between PostgreSQL servers
and a PostgreSQL database client. It talks PostgreSQL's backend
and frontend protocol, and relays a connection between them.