Port details |
- pgpool-II-36 Connection pool server for PostgreSQL
- 3.6.28 databases
=1 3.6.28Version of this port present on the latest quarterly branch. DEPRECATED: Upstream support ended use databases/pgpool-II-43
EXPIRATION DATE: 2022-06-30
- Maintainer: tz@FreeBSD.org
 - Port Added: 2017-05-16 10:57:57
- Last Update: 2022-03-23 14:25:48
- Commit Hash: 04990a8
- People watching this port, also watch:: zrep
- License: MIT
- Description:
- 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: https://pgpool.net/
- SVNWeb : git : Homepage
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- For RUN/BUILD depends:
- pgpool-II36>0:databases/pgpool-II-36
- For LIB depends:
- libpcp.so:databases/pgpool-II-36
- Conflicts:
- CONFLICTS:
- Conflicts Matches:
-
There are no Conflicts Matches for this port. This is usually an error.
- To install the port:
- cd /usr/ports/databases/pgpool-II-36/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/pgpool-II-36
- pkg install pgpool-II36
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: pgpool-II36
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1640293881
SHA256 (pgpool-II-3.6.28.tar.gz) = b2b7c04e687d9205601d8a2e48413a50bd64bd4d30e3ac0ec553fba61f2678f6
SIZE (pgpool-II-3.6.28.tar.gz) = 3363962
- Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.3 : devel/gmake
- Library dependencies:
-
- libpq.so.5 : databases/postgresql13-client
- There are no ports dependent upon this port
- Configuration Options:
- ===> The following configuration options are available for pgpool-II36-3.6.28:
DOCS=on: Build and/or install documentation
SSL=on: SSL protocol support
===> Use 'make config' to modify these settings
- Options name:
- databases_pgpool-II-36
- USES:
- gmake libtool pgsql:9.3+ ssl
- pkg-message:
- For install:
- In order to start pgpool you need some more configuration:
# sysrc -f /etc/rc.conf pgpool_enable="YES"
# sysrc -f /etc/rc.conf pgpool_user="root"
Please consider the usage of another user. The user is
required to have read/write access to /var/run/pgpool.
Using the root user is - as always - an security issue.
- Master Sites:
|
Commit History - (may be incomplete: see SVNWeb link above for full details) |
Date | By | Description |
23 Mar 2022 14:25:48 3.6.28
|
Muhammad Moinur Rahman (bofh)  |
databases/pgpool-II-36: Mark DEPRECATED
- pgpool-II-36 or 3.6 series has reached EOL on 2021-11
- Set EXPIRATION_DATE on 2022-06-30
See also:
https://pgpool.net/mediawiki/index.php/EOL_information
Approved by: tz (private email)
Sponsored by: Bounce Experts |
26 Dec 2021 19:05:13 3.6.28
|
Muhammad Moinur Rahman (bofh)  |
databases/pgpool-II-36: Update version 3.6.21=>3.6.28
Approved by: tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-3-6-28.html
Sponsored by: Bounce Experts |
29 Oct 2021 09:50:18 3.6.21
|
Stefan Eßer (se)  |
*/*: Remove redundant '-[0-9]*' from CONFLICTS
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) |
07 Apr 2021 08:09:01 3.6.21
|
Mathieu Arnold (mat)  |
One more small cleanup, forgotten yesterday.
Reported by: lwhsu |
06 Apr 2021 14:31:13 3.6.21
|
Mathieu Arnold (mat)  |
all: Remove all other $FreeBSD keywords. |
06 Apr 2021 14:31:07 3.6.21
|
Mathieu Arnold (mat)  |
Remove # $FreeBSD$ from Makefiles. |
15 Jul 2020 18:06:18
3.6.21
|
tz  |
databases/pgpool-II-36: Upgrade from 3.6.20 to 3.6.21
Bug fixes
Fix build error on some system (Fedora 32). (Tatsuo Ishii)
Fix unnecessary checks. (Tatsuo Ishii)
Doc: Fix typo. (Tatsuo Ishii)
Fix for segmentation fault in PCP process. (bug 598) (Muhammad Usama)
Doc: Fix typo. (Tatsuo Ishii, Bo Peng)
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)
Sponsored by: Bounce Experts |
15 Mar 2020 21:15:38
3.6.20
|
tz  |
databases/pgpool-II-36: Update from 3.6.18 to 3.6.20
Changelog for 3.6.19:
Bug fixes
Fix incorrect query rewrite in replication mode. (Bo Peng)
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 assorted ancient v2 protocol bugs. (Tatsuo Ishii)
Fix problem that syslog_facility doesn't change by reload. (bug 548) (Takuma
Hoshiai) (Only the first 15 lines of the commit message are shown above ) |
31 Aug 2019 21:21:05
3.6.18
|
tz  |
databases/pgpool-II-36: Upgrade from 3.6.17 to 3.6.18
Changelog:
Enhancements:
- 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: (Only the first 15 lines of the commit message are shown above ) |
13 Aug 2019 16:01:59
3.6.17_1 
|
mat  |
Convert to UCL & cleanup pkg-message (categories d) |
26 Jul 2019 20:46:57
3.6.17_1
|
gerald  |
Bump PORTREVISION for ports depending on the canonical version of GCC
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 |
17 May 2019 08:37:37
3.6.17
|
tz  |
databases/pgpool-II-36: Upgrade from 3.6.16 to 3.6.17
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) (Only the first 15 lines of the commit message are shown above ) |
08 Apr 2019 07:11:25
3.6.16
|
tz  |
databases/pgpool-II-36: Upgrade from 3.6.15 to 3.6.16
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.
Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-6-16.html
MFH: 2019Q2 |
08 Mar 2019 15:55:05
3.6.15
|
tz  |
databases/pgpool-II-36: Update from 3.6.14 to 3.6.15
Changelog:
- Test: Fix old JDBC functions and typos in regression test 068.memqcache_bug.
- Doc: Fix configuration change timing regarding memory_cache_enabled.
- Fix online recovery failed due to client_idle_limit_in_recovery in certain
cases. (bug 431)
- Fix corner case bug when strip_quote() handle a empty query string. (bug 458)
- Doc: Mention that schema qualifications cannot be used in
white/black_function_list.
- Fix typo about wd_priority in watchdog_setup.
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection.
- Doc: fix typo in logdir description. (bug 453)
- Fix Pgpool-II hang if a client sends a extended query message such as close
after sync message but before next simple query.
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on. (bug 448)
- Doc: Fix Japanese document typo in pcp_common_options.
Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-6-15.html
MFH: 2019Q1 |
12 Dec 2018 01:35:36
3.6.14_1
|
gerald  |
Bump PORTREVISION for ports depending on the canonical version of GCC
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 |
27 Nov 2018 09:35:34
3.6.14
|
tz  |
databases/pgpool-II-36: Upgrade from 3.6.13 to 3.6.14
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-14.html |
22 Nov 2018 09:32:45
3.6.13
|
tobik  |
databases/pgpool-II-* build fine with OpenSSL 1.1.1 too
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-3.4.20.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II35-3.5.17.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II36-3.6.13.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II37-3.7.6.log |
15 Nov 2018 22:09:04
3.6.13
|
joneum  |
Fix WWW
Approved by: tz (implicit)
Sponsored by: Netzkommune GmbH |
15 Nov 2018 21:51:47
3.6.13
|
joneum  |
Update to 3.6.13
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-13.html
Approved by: tz (implicit)
Sponsored by: Netzkommune GmbH |
10 Nov 2018 10:09:49
3.6.12
|
mat  |
security/openssl-devel was removed, but there is a security/openssl111 now. |
31 Jul 2018 08:16:40
3.6.12
|
tz  |
databases/pgpool-II-36: Update from 3.6.11 to 3.6.12
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-16.html |
27 Jun 2018 11:02:48
3.6.11
|
tz  |
databases/pgpool-II-36: Update from 3.6.10 to 3.6.11
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-11.html |
18 Apr 2018 11:20:04
3.6.10
|
tz  |
databases/pgpool-II-36: Update from 3.6.9 to 3.6.10
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-10.html |
17 Apr 2018 09:08:34
3.6.9
|
tz  |
databases/pgpool-II-36: allow configuration of stop_mode
PR: 221312 |
21 Feb 2018 11:15:21
3.6.9
|
tz  |
databases/pgpool-II-36: Update from 3.6.6 to 3.6.9
Changelogs:
- http://www.pgpool.net/docs/latest/en/html/release-3-6-7.html
- http://www.pgpool.net/docs/latest/en/html/release-3-6-8.html
- http://www.pgpool.net/docs/latest/en/html/release-3-6-9.html |
16 Feb 2018 17:52:50
3.6.6
|
brnrd  |
BROKEN_SSL: Add REASON for breakage
Reported by: matwq |
16 Feb 2018 14:03:22
3.6.6
|
brnrd  |
security/openssl-devel: Mark broken databases cat |
19 Sep 2017 10:42:07
3.6.6
|
tz  |
databases/pgpool-II-36: Update from 3.6.4 to 3.6.6
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-5.html
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-6.html |
16 May 2017 20:01:43
3.6.4
|
antoine  |
Fix PKGBASE collision with databases/pgpool |
16 May 2017 10:57:49
3.6.4
|
tz  |
New port: databases/pgpool-II-36
This is an repo-copy of databases/pgpool-II-35 updated to 3.6.4
PR: 206839 |