![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / pgpool2
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
pgpool2: update HOMEPAGE + fix build error on SunOS
pgpool2: updated to 4.3.2 4.3.2 Changes Enhance in stopping pgpool main process. (Tatsuo Ishii) If "pgpool stop" couldn't terminate the main process within certain period (currently 5 seconds), send the signal again. Fix not to abort session while in failed transaction. (Tatsuo Ishii) When an explicit transaction fails, subsequent commands should be ignored until commit or rollback command comes in. However pgpool sometimes aborted the session if relcache lookup happened. Change the PID length of pcp_proc_count command to 7 characters long. (Bo Peng) Enhance error message to include the message kind returned and the backend node id while processing parse message. (Tatsuo Ishii) Downgrade log level of ParameterStatus message from LOG to DEBUG5. (Tatsuo Ishii) Change the default value of pcp_listen_addresses from '*' to 'localhost'. (Tatsuo Ishii) Adjust the field name in pcp_watchdog_info. (Muhammad Usama) Enable parameters related to logging_collector by default in RPM packages. (Bo Peng) Bug fixes Fix issue that watchdog cluster keeps rejecting the restarted remote node which is lost previously. (Muhammad Usama) Fix exit_handler in pgpool main process to avoid possible infinite wait. (Tatsuo Ishii) Fix pgpool child process to obtain process information. (Tatsuo Ishii) Fix a potential issue in shared memory allocation function. (Tatsuo Ishii) Fix bug with pg_enc and pg_md5 when using "-i" option. (bug 747)(Tatsuo Ishii) Fix not to include garbage in %m log_line_prefix. (Tatsuo Ishii) Fix main process exiting if a backend is failing or shutting down while performing finding primary. (Tatsuo Ishii) Fix segfaults in watchdog. (Muhammad Usama) Fix issue that failover request is refused if backend node status managed in private_backend_status and the one in the share memory area do not agree. (Tatsuo Ishii) Fixed follow_primary.sh.sample script to check the status of PostgreSQL using pg_isready. (Bo Peng) Documents Doc: move the example of "Pgpool-II on Kubernetes" to github repository. (Bo Peng) Doc: update configuration example. (Masaya Kawamoto) Doc: update the example output of pcp_watchdog_info. (Bo Peng) Doc: mention that escaping is required if you are providing the password as an argument to pg_enc and the password contains a "$" character. (Bo Peng) Regression Tests Enhance regression test 018.detach_primary to avoid the timeut error. (Tatsuo Ishii) Enhance regression test 074.bug700_memqcache_segfault to avoid the timeut error. (Tatsuo Ishii) Improve regression test to detect segmentation fault. (Bo Peng) Increase timeout for regression test 077.invalid_failover_node. (Tatsuo Ishii)
pgpool2: updated to 4.3.1 4.3.1 Suppress message length log for in_hot_standby. Change the default value for log_line_prefix. Add validations of wd_lifecheck_password and recovery_password format. Enhance parameter status handling. Bug fixes 4.3.0 Many enhancements are added to this version for easier configuration and administration. A new cluster membership mechanism is introduced to dynamically adjust the Watchdog cluster size. This allows the leader Watchdog node to retain the quorum/VIP even when some of watchdog nodes get Shutdown or disconnected. New PostgreSQL 14 SQL parser is imported. The Snapshot Isolation Mode is now ready for production. New sample configuration for the mode is provided in the configuration example section.
databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
databases: Remove SHA1 distfile hashes
pgpool2: update to 4.2.2.
Based on a diff provided by Mustafa Dogan.
4.2.1 and 4.2.2 are bugfix releases.
4.2 contains new features and enhancements, including:
Some items in the configuration file pgpool.conf are vastly
enhanced for easier configuration and administration.
Implement logging_collector for easier log management.
Implement log_disconnections to collect disconnection logs.
Implement pg_enc and pg_md5 to allow to register multiple
passwords at once.
Allow to show statistics of health check by using SHOW
POOL_HEALTH_CHECK_STATS command, and also allow to show statistics
of issued SQL by using SHOW POOL_BACKEND_STATS command.
New PCP command pcp_reload_config is added.
Now it is possible to omit write_function_list and
read_only_function_list by looking at system catalog information.
Add new clustering mode snapshot_isolation_mode which guarantees
not only data modifications to multiple PostgreSQL but read
consistency.
Support LDAP authentication between clients and Pgpool-II.
Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
Import PostgreSQL 13's SQL parser.
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 code. - 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 watchdog. - 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: 2312]. 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 pool_config_vatiable.c - Removing the references of obsolete debug_level configuration parameter. - 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 connecttions. 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 client_idle_limit_in_recovery. - Allow to execute "make xslthtml" under doc.ja.
Update databases/pgpool2 to 3.6.0. 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. 3.5.4 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 inavailability. - 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 restored. - 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 string. 3.5.3 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 mode. - 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. 3.5.2 Bugfixes - 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 long 3.5.1 Bugfixes - 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
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.