aboutsummaryrefslogtreecommitdiff
path: root/databases/pgpool-II-40
Commit message (Collapse)AuthorAgeFilesLines
* databases/pgpool-II-40: Update version 4.0.21=>4.0.22Muhammad Moinur Rahman2023-02-202-4/+10
| | | | | | | | Changelog: https://www.pgpool.net/docs/latest/en/html/release-4-0-22.html Approved by: tz (mail) Sponsored by: Bounce Experts
* databases/pgpool-II-40: Update version 4.0.20=>4.0.21Muhammad Moinur Rahman2022-12-312-4/+4
| | | | | | Approved by: tz (by private email) Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-21.html Sponsored by: Bounce Experts
* Remove WWW entries moved into port MakefilesStefan Eßer2022-09-071-2/+0
| | | | | | | | | | Commit b7f05445c00f has added WWW entries to port Makefiles based on WWW: lines in pkg-descr files. This commit removes the WWW: lines of moved-over URLs from these pkg-descr files. Approved by: portmgr (tcberner)
* Add WWW entries to port MakefilesStefan Eßer2022-09-071-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | It has been common practice to have one or more URLs at the end of the ports' pkg-descr files, one per line and prefixed with "WWW:". These URLs should point at a project website or other relevant resources. Access to these URLs required processing of the pkg-descr files, and they have often become stale over time. If more than one such URL was present in a pkg-descr file, only the first one was tarnsfered into the port INDEX, but for many ports only the last line did contain the port specific URL to further information. There have been several proposals to make a project URL available as a macro in the ports' Makefiles, over time. This commit implements such a proposal and moves one of the WWW: entries of each pkg-descr file into the respective port's Makefile. A heuristic attempts to identify the most relevant URL in case there is more than one WWW: entry in some pkg-descr file. URLs that are not moved into the Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr files in order to preserve them. There are 1256 ports that had no WWW: entries in pkg-descr files. These ports will not be touched in this commit. The portlint port has been adjusted to expect a WWW entry in each port Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as deprecated. Approved by: portmgr (tcberner)
* databases/pgpool-II-40: Update version 4.0.19=>4.0.20Muhammad Moinur Rahman2022-09-042-4/+4
| | | | | | Approved by: tz (By private mail) Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-20.html Sponsored by: Bounce Experts
* Fix CONFLICTS_INSTALL in the databases categoryStefan Eßer2022-06-291-1/+1
| | | | Approved by: portmgr (implicit)
* databases/pgpool-II-40: Update version 4.0.17=>4.0.19Muhammad Moinur Rahman2022-06-272-14/+13
| | | | | | Approved by: tz (private email) Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-19.html Sponsored by: Bounce Experts
* databases/pgpool-II-40: Update version 4.0.9=>4.0.17Muhammad Moinur Rahman2021-12-262-8/+8
| | | | | | Approved by: tz (private email) Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-0-17.html Sponsored by: Bounce Experts
* */*: Remove redundant '-[0-9]*' from CONFLICTSStefan Eßer2021-10-291-1/+1
| | | | | | | | | | | | | The conflict checks compare the patterns first against the package names without version (as reported by "pkg query "%n"), then - if there was no match - agsinst the full package names including the version (as reported by "pkg query "%n-%v"). Many CONFLICTS definitions used patterns like "bash-[0-9]*" to filter for the bash package in any version. But that pattern is functionally identical with just "bash". Approved by: portmgr (blanket)
* One more small cleanup, forgotten yesterday.Mathieu Arnold2021-04-071-1/+0
| | | | Reported by: lwhsu
* all: Remove all other $FreeBSD keywords.Mathieu Arnold2021-04-061-3/+1
|
* Remove # $FreeBSD$ from Makefiles.Mathieu Arnold2021-04-061-1/+0
|
* databases/pgpool-II-40: fix broken SIZE in distinfoTorsten Zuehlsdorff2020-07-161-3/+3
| | | | | | | | | | File has not changed, it was just broken on my latest download because of bad internet connection. Sponsored by: Bounce Experts Notes: svn path=/head/; revision=542391
* databases/pgpool-II-40: Update from 4.0.8 to 4.0.9Torsten Zuehlsdorff2020-07-152-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog: Bug fixes Fix build error on some system (Fedora 32). (Tatsuo Ishii) Fix pgpool ssl front end accept all ciphers. (bug 608) (Muhammad Usama) Downgrade too verbose authentication logs. (Tatsuo Ishii) Fix unnecessary checks. (Tatsuo Ishii) Doc: Fix typo. (Tatsuo Ishii) Fix for segmentation fault in PCP process. (bug 598) (Muhammad Usama) Fix a warning message is never output in watchdog. (Tatsuo Ishii) Doc: Fix typo. (Tatsuo Ishii, Bo Peng) Fix Pgpool-II hangs when an Execute message is issued right after Sync message and query cache hits. (Tatsuo Ishii) Fix problems in watchdog source code processing json data. (bug 596) (Tatsuo Ishii) Fix SCRAM auth handling bug. (bug 595) (Tatsuo Ishii) Fix possible data inconsistency in native replication mode. (Tatsuo Ishii) Fix watchdog ping probes fail with long hostnames due to small buffer. (bug 516) (Bo Peng) Doc: Enhance documents. (Tatsuo Ishii) Fix "last status change" timestamp is not set properly. (Tatsuo Ishii) Sponsored by: Bounce Experts Notes: svn path=/head/; revision=542281
* databases/pgpool-II-40: Upgrade from 4.0.6 to 4.0.8Torsten Zuehlsdorff2020-03-152-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog for 4.0.7: Bug fixes Fix incorrect query rewrite in replication mode. (Bo Peng) Fix that health check timeout does work in certain case. (Tatsuo Ishii) Discussion: [pgpool-hackers: 3458], [pgpool-hackers: 3459] Doc: add failover_command description when all standby nodes are down. (Takuma Hoshiai) Doc: add note not to assign PostgreSQL servers to trusted_servers. (Tatsuo Ishii) Fix for miscellaneous watchdog issues. (Muhammad Usama) Fix assorted ancient v2 protocol bugs. (Tatsuo Ishii) Fix problem that syslog_facility doesn't change by reload. (bug 548) (Takuma Hoshiai) Fix Pgpool-II shutdown failed in certain case. (Tatsuo Ishii) Allow the lost standby node to rejoin the master watchdog node when it gets rediscovered by the lifecheck. (bug 545) (Muhammad Usama) Overhaul health check debug facility. (Tatsuo Ishii) Fix segfault when executing an erroneous query after DEALLOCATE a named statement. (bug 546) (Tatsuo Ishii) Doc: clarify that certificate authentication works between only client and Pgpool-II. (Tatsuo Ishii) Doc: update configuration Examples "Pgpool-II + Watchdog Setup Example". (Bo Peng) Doc: mention that VIP will not be brougt up if quorum does not exist. (Tatsuo Ishii) Fix pgpool_setup to deal with PostgreSQL 9.1. (Tatsuo Ishii) Fix for password authentication does not work when the password for the connecting user is not found in the pool_passwd file. (bug 534) (Muhammad Usama) Add "-I" option to arping_cmd command default setting. (Bo Peng) Changelog taken from: https://www.pgpool.net/docs/latest/en/html/release-4-0-7.html Changelog for 4.0.8: Changes Disallowing the quorum aware failover option for the native replication mode. (Muhammad Usama) Check if socket file exists at startup and remove them if PID file doesn't exist to avoid bind() failire. (Bo Peng) Bug fixes Fix incorrect query rewriting in native replication mode. (bug 551) (Bo Peng) Doc: Update documentation and fix documentation typos. (Takuma Hoshiai, Tatsuo Ishii, Bo Peng) Fix child process segfault after reload if health_check_database is empty. (bug 571) (Bo Peng) Fix pgpool_setup to support PostgreSQL 12. (Tatsuo Ishii) Doc: Change the sample follow_master_command script %M %H paramater's order. (Bo Peng) Fix occasional regression test failure. (Tatsuo Ishii) Fix replication delay worker segfault when application_name in primary_conninfo is an empty string. (bug 565) (Tatsuo Ishii) Fix PGPOOL SHOW command doesn't display ALWAYS_MASTER, when backend_flag = 'ALWAYS_MASTER'. (Takuma Hoshiai) Fix the bug with ignored syslog setting. (Bo Peng) Changelog taken from: https://www.pgpool.net/docs/latest/en/html/release-4-0-8.html Notes: svn path=/head/; revision=528505
* databases/pgpool-II-40: Upgrade from 4.0.5 to 4.0.6Torsten Zuehlsdorff2019-08-312-5/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog: Enhancements: - Doc: Update "Pgpool-II + Watchdog Setup Example" to support PostgreSQL 12. (Bo Peng) - Import some of memory manager debug facilities from PostgreSQL. (Tatsuo Ishii) - Use pg_get_expr() instead of pg_attrdef.adsrc to support for PostgreSQL 12. (Bo Peng) - Enhance shutdown script of pgpool_setup. (Tatsuo Ishii) - Make shutdownall to wait for completion of shutdown of Pgpool-II. - If environment variable CHECK_TIME_WAIT is set to true, use netstat command to confirm usage of the TCP/IP port while executing shutdown script. - Doc: add description to pg_md5 man page how to show pool_passwd hashed string. (Tatsuo Ishii) - Doc: add general description about failover. (Tatsuo Ishii) - Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii) Bug fixes: - Test: Fix test failure of extended-query-test when disable_load_balance_on_write = off/transaction/always. (Tatsuo Ishii) - Fix "unable to bind. cannot get parse message" error. (bug 531) (Tatsuo Ishii) - Fix online-recovery is blocked after a child process exits abnormally with replication mode and watchdog. (bug 483) (Muhammad Usama) - Fix for keep the backend health check running on quarantined nodes. (Muhammad Usama) - Fix for no primary on standby pgpool when primary is quarantined on master. (Muhammad Usama) - Fix watchdog_setup command mode option to work correctly. (Takuma Hoshiai) - Fix pgpool_setup to produce correct follow master command. (Tatsuo Ishii) - Fix query cache module so that it checks oid array's bound. (Tatsuo Ishii) - Fix off-by-one error in query cache module. (Tatsuo Ishii) - Allow health check process to reload. (Tatsuo Ishii) - Fix sefault when query cache is enabled. (bug 525) (Tatsuo Ishii) - Down grade LOG "checking zapping sent message ..." to DEBUG5. (Tatsuo Ishii) - Fix segfault when samenet is specified in pool_hba.conf. (Tatsuo Ishii) - Doc: Fix documentation mistakes in follow_master.sh script and typos. (Bo Peng) - Fix health check process is not shutting down in certain cases. (Tatsuo Ishii) - Fix to deal with backslashes according to the config of standard_conforming_strings in native replication mode. (bug 467) (Bo Peng) - Fix compile error on FreeBSD. (bug 512, bug 519) (Bo Peng) - Fix memory leaks. (Tatsuo Ishii) - Make failover in progress check more aggressively to avoid potential segfault. (Tatsuo Ishii) MFH: 2019Q3 Notes: svn path=/head/; revision=510422
* Convert to UCL & cleanup pkg-message (categories d)Mathieu Arnold2019-08-131-0/+6
| | | | Notes: svn path=/head/; revision=508835
* Bump PORTREVISION for ports depending on the canonical version of GCCGerald Pfeifer2019-07-261-0/+1
| | | | | | | | | | | | | | | | | | as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3 to GCC 9.1 under most circumstances now after revision 507371. This includes ports - with USE_GCC=yes or USE_GCC=any, - with USES=fortran, - using Mk/bsd.octave.mk which in turn features USES=fortran, and - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang, c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib plus, everything INDEX-11 shows with a dependency on lang/gcc9 now. PR: 238330 Notes: svn path=/head/; revision=507372
* databases/pgpool-II-40: Upgrade from 4.0.4 to 4.0.5Torsten Zuehlsdorff2019-05-172-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog: Enhancements - Doc: Improve Reference II, PCP commands document. (Tatsuo Ishii) - Speed up failover when all of backends are down. (Tatsuo Ishii) - pgpool-recovery extension and pgpool_setup is now ready for the next major release PostgreSQL 12. (Tatsuo Ishii) - Doc: add restrictions entry. (Takuma Hoshiai) Bug fixes - Fix the wrong error message "ERROR: connection cache is full", when all backend nodes are down. (bug 487) (Bo Peng) - Remove unused .sgml file. (Takuma Hoshiai) - Avoid exit/fork storm of pool_worker_child process. (Tatsuo Ishii) - Fix black_function_list's broken default value. (Tatsuo Ishii) - Fix "not enough space in buffer" error. (bug 499) (Tatsuo Ishii) - Fix DROP DATABASE failure. (Tatsuo Ishii) - Fix wrong variable in read_status_file() function. (bug 493) (Takuma Hoshiai) - Add missing test/watchdog_setup to EXTRA_DIST. (bug 470) (Bo Peng) - Doc: mention that multi-statement queries are sent to primary node only. (bug 492) (Tatsuo Ishii) - Fix md5 auth broken in raw mode with more than 1 backends. (bug 491) (Tatsuo Ishii) - Test: Fix occasional regression test failure of 014.watchdog_test_quorum_bypass. (Tatsuo Ishii) - Abort session if failover/failback is ongoing to prevent potential segfault. (bug 481, bug 482) (Tatsuo Ishii) - Fix compiler warnings. (Tatsuo Ishii) - Fix memory leak in "batch" mode in extended query. (bug 468) (Tatsuo Ishii) Changelog taken from: http://www.pgpool.net/docs/latest/en/html/release-4-0-5.html MFH: 2019Q2 Notes: svn path=/head/; revision=501845
* databases/pgpool-II-40: Upgrade from 4.0.3 to 4.0.4Torsten Zuehlsdorff2019-04-082-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog: Enhancements * Add new configuration option ssl_prefer_server_ciphers. (Muhammad Usama) Add the new setting ssl_prefer_server_ciphers to let users configure if they want client's or server's cipher order to take preference. The default for this parameter is off, which prioritize the client's cipher order as usual. However this is just for keeping backward compatibility, and it is possible that a malicious client uses weak ciphers. For this reason we recommend to set this parameter to on at all times. * Allow to set a client cipher list. (Tatsuo Ishii, Yugo Nagata) For this purpose new parameter ssl_ciphers, which specifies the cipher list to be accepted by Pgpool-II, is added. This is already implemented in PostgreSQL and useful to enhance security when SSL is enabled. Bug fixes * Fix unnecessary fsync() to pgpool_status file. (Tatsuo Ishii) Whenever new connections are created to PostgreSQL backend, fsync() was issued to pgpool_status file, which could generate excessive I/O in certain conditions. So reduce the chance of issuing fsync() so that it is issued only when backend status is changed. * Doc: add more explanation to follow_master_command. (Tatsuo Ishii) Add description how follow_master_command is executed etc. * Doc: add note to detach_false_primary configuration parameter. (bug 469) (Tatsuo Ishii) To use this feature, sr_check_user must be super user or in pg_monitor group. Changelog taken from: http://www.pgpool.net/docs/latest/en/html/release-4-0-4.html MFH: 2019Q2 Notes: svn path=/head/; revision=498353
* databases/pgpool-II-40: Update from 4.0.2 to 4.0.3Torsten Zuehlsdorff2019-03-082-5/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Changelog: - Skip over "host=" when getting info from conninfo string. (Bo Peng) - Test: Fix old JDBC functions and typos in regression test 068.memqcache_bug. (Takuma Hoshiai) - Doc: Fix configuration change timing regarding memory_cache_enabled. (Tatsuo Ishii) - Fix online recovery failed due to client_idle_limit_in_recovery in certain cases. (bug 431) (Tatsuo Ishii) - Reduce memory usage when large data set is returned from backend. (bug 462) (Tatsuo Ishii) - Test: Fix syntax error in extended query test script. (Tatsuo Ishii) - Fix corner case bug when strip_quote() handle a empty query string. (bug 458) (Tatsuo Ishii) - Doc: Mention that schema qualifications cannot be used in white/black_function_list. (Tatsuo Ishii) - Fix typo about wd_priority in watchdog_setup. (Takuma Hoshiai) - Fixed segfault when wd_lifecheck_method = 'query'. (bug 455) (Muhammad Usama) - The fix was proposed by Muhammad Usama and some adjustments to the patch and testing is done by Yugo Nagata. - Fix Pgpool child segfault if failover occurs when trying to establish a connection. (Tatsuo Ishii) - Doc: fix typo in logdir description. (bug 453) (Tatsuo Ishii) - Fix PAM authentication failed. (Takuma Hoshiai) - Fix Pgpool-II hang if a client sends a extended query message such as close after sync message but before next simple query. (Tatsuo Ishii) - Fix Pgpool-II hang when idle_in_transaction_session_timeout = on. (bug 448) (Tatsuo Ishii) Changelog taken from: http://www.pgpool.net/docs/latest/en/html/release-4-0-3.html MFH: 2019Q1 Notes: svn path=/head/; revision=495052
* databases/pgpool-II-40: add new configuration files to rc-scriptTorsten Zuehlsdorff2019-01-282-10/+20
| | | | | | | | | | | | pgpool 4.0 adds the configuration files "pool_hba.conf" and "pcp.conf", but they weren't used until now. Also its possible to change there location via rc.conf PR: 235059 Submitted by: Franco Ricci <franco.ricc@gmail.com> Notes: svn path=/head/; revision=491466
* databases/pgpool-II-40: Actually unbreak PAM option after r490475Tobias Kortkamp2019-01-171-1/+1
| | | | | | | | | | | | | | | | | | Do not pass --without-pam to configure as it does not appear to work correctly. It also defines USE_PAM in config.h even when it should not be defined and the build breaks. auth/pool_hba.c:157:24: error: variable has incomplete type 'struct pam_conv' static struct pam_conv pam_passw_conv = { ^ http://beefy3.nyi.freebsd.org/data/112amd64-quarterly/490502/logs/errors/pgpool-II40-4.0.2_2.log Pointy hat: tobik Approved by: tz (maintainer) Notes: svn path=/head/; revision=490545
* databases/pgpool-II-40: Unbreak PAM optionTobias Kortkamp2019-01-161-13/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | The PAM option is tangled up with the SSL option in a weird way. SSL_CONFIGURE_WITH is set once before bsd.port.options.mk for enabling SSL support and overwritten again after including bsd.port.options.mk but only when PAM=on. Setting options helper after this point is not really supported, but --with-pam actually makes it to CONFIGURE_ARGS. When options helpers are processed the results are only realized later by make(1). SSL_CONFIGURE_WITH has been defined before including bsd.port.options.mk, so this sort of "works". This, however, is presumably an implementation detail and enabling the PAM option breaks SSL support since SSL_CONFIGURE_WITH is overwritten with a new value: CONFIGURE_ARGS only has --with-pam left and is missing --with-openssl. PAM support does not depend on SSL support. Just switch everything to options helpers to fix this. PR: 234817 Submitted by: tobik Approved by: tz (maintainer) Notes: svn path=/head/; revision=490475
* Bump PORTREVISION for ports depending on the canonical version of GCCGerald Pfeifer2018-12-121-0/+1
| | | | | | | | | | | | | | | | | | defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t GCC 8.2 under most circumstances. This includes ports - with USE_GCC=yes or USE_GCC=any, - with USES=fortran, - using Mk/bsd.octave.mk which in turn features USES=fortran, and - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang, c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib plus, as a double check, everything INDEX-11 showed depending on lang/gcc7. PR: 231590 Notes: svn path=/head/; revision=487272
* databases/pgpool-II-40: Upgrade from 4.0.1 to 4.0.2Torsten Zuehlsdorff2018-11-272-4/+4
| | | | | | | Changelog: http://www.pgpool.net/docs/latest/en/html/release-4-0-2.html Notes: svn path=/head/; revision=485998
* databases/pgpool-II-40: Drop incorrect BROKEN_SSLTobias Kortkamp2018-11-221-3/+0
| | | | | | | | | | | | | | openssl-devel was removed a while ago in favor of openssl111, but pgpool-II-40 builds fine with OpenSSL 1.1.1, so BROKEN_SSL is not needed in the first place. http://beefy5.nyi.freebsd.org/data/120i386-default/485373/logs/pgpool-II40-4.0.1.log http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II40-4.0.1.log Pointy hat: joneum Notes: svn path=/head/; revision=485584
* Fix WWWJochen Neumeister2018-11-151-1/+1
| | | | | | | | Approved by: tz (implicit) Sponsored by: Netzkommune GmbH Notes: svn path=/head/; revision=485055
* New Port: databases/pgpool-II-40Jochen Neumeister2018-11-157-0/+168
pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can connect to pgpool as if it were a standard PostgreSQL server. pgpool caches the connection to PostgreSQL server to reduce the overhead to establish the connection to it. WWW: http://pgpool.net/ PR: 232957 Reported by: Franco Ricci <franco.ricc@gmail.com> Approved by: tz (implicit) Sponsored by: Netzkommune GmbH Notes: svn path=/head/; revision=485048
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-25 05:55:52 +0000