notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
pgpool-II-36 Connection pool server for PostgreSQL
3.6.20 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 3.6.20Version of this port present on the latest quarterly branch.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-05-16 10:57:57
Last Update: 2020-03-15 21:15:38
SVN Revision: 528503

People watching this port, also watch: nfs-ganesha, zrep

License: MIT
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (36 items)
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II36-3.6.20/catalog.mk
  3. /usr/local/share/licenses/pgpool-II36-3.6.20/LICENSE
  4. /usr/local/share/licenses/pgpool-II36-3.6.20/MIT
  5. bin/pcp_attach_node
  6. bin/pcp_detach_node
  7. bin/pcp_node_count
  8. bin/pcp_node_info
  9. bin/pcp_pool_status
  10. bin/pcp_proc_count
  11. bin/pcp_proc_info
  12. bin/pcp_promote_node
  13. bin/pcp_recovery_node
  14. bin/pcp_stop_pgpool
  15. bin/pcp_watchdog_info
  16. bin/pg_md5
  17. bin/pgpool
  18. bin/pgpool_setup
  19. bin/watchdog_setup
  20. @sample etc/pcp.conf.sample
  21. @sample etc/pgpool.conf.sample
  22. etc/pgpool.conf.sample-master-slave
  23. etc/pgpool.conf.sample-replication
  24. etc/pgpool.conf.sample-stream
  25. @sample etc/pool_hba.conf.sample
  26. include/libpcp_ext.h
  27. include/pcp.h
  28. include/pool_process_reporting.h
  29. include/pool_type.h
  30. lib/libpcp.a
  31. lib/libpcp.so
  32. lib/libpcp.so.1
  33. lib/libpcp.so.1.0.0
  34. share/pgpool-II/insert_lock.sql
  35. share/pgpool-II/pgpool.pam
  36. @dir /var/run/pgpool
Collapse this list.
Dependency lines:
  • pgpool-II36>0:databases/pgpool-II-36
  • libpcp.so:databases/pgpool-II-36
Conflicts:
CONFLICTS:
  • pgpool-II-[0-9]*
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: pkg install pgpool-II36
PKGNAME: pgpool-II36
Flavors: there is no flavor information for this port.
distinfo:
Packages:
pgpool-II36
ABIlatestquarterly
FreeBSD:11:aarch643.6.123.6.20
FreeBSD:11:amd643.6.203.6.20
FreeBSD:11:i3863.6.203.6.20
FreeBSD:12:aarch643.6.123.6.20
FreeBSD:12:amd643.6.203.6.20
FreeBSD:12:i3863.6.203.6.20
FreeBSD:13:aarch643.6.20-
FreeBSD:13:amd643.6.20-
FreeBSD:13:i3863.6.20-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake : devel/gmake
Library dependencies:
  1. libpq.so.5 : databases/postgresql11-client
There are no ports dependent upon this port

Configuration Options

USES:

pkg-message:
If installing:
Master Sites:
  1. http://www.pgpool.net/mediawiki/images/

Number of commits found: 23

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
15 Mar 2020 21:15:38
Original commit files touched by this commit  3.6.20
Revision:528503
tz search for other commits by this committer
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 View all of this commit message)
31 Aug 2019 21:21:05
Original commit files touched by this commit  3.6.18
Revision:510420
tz search for other commits by this committer
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 View all of this commit message)
13 Aug 2019 16:01:59
Original commit files touched by this commit  3.6.17_1
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
26 Jul 2019 20:46:57
Original commit files touched by this commit  3.6.17_1
Revision:507372
gerald search for other commits by this committer
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
Original commit files touched by this commit  3.6.17
Revision:501843
tz search for other commits by this committer
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 View all of this commit message)
08 Apr 2019 07:11:25
Original commit files touched by this commit  3.6.16
Revision:498351
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.15
Revision:495050
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.14_1
Revision:487272
gerald search for other commits by this committer
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
Original commit files touched by this commit  3.6.14
Revision:485996
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.13
Revision:485587
tobik search for other commits by this committer
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
Original commit files touched by this commit  3.6.13
Revision:485055
joneum search for other commits by this committer
Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
15 Nov 2018 21:51:47
Original commit files touched by this commit  3.6.13
Revision:485053
joneum search for other commits by this committer
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
Original commit files touched by this commit  3.6.12
Revision:484599
mat search for other commits by this committer
security/openssl-devel was removed, but there is a security/openssl111 now.
31 Jul 2018 08:16:40
Original commit files touched by this commit  3.6.12
Revision:475977
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.11
Revision:473431
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.10
Revision:467704
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.9
Revision:467584
tz search for other commits by this committer
databases/pgpool-II-36: allow configuration of stop_mode

PR: 221312
21 Feb 2018 11:15:21
Original commit files touched by this commit  3.6.9
Revision:462491
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.6
Revision:462050
brnrd search for other commits by this committer
BROKEN_SSL: Add REASON for breakage

Reported by:	matwq
16 Feb 2018 14:03:22
Original commit files touched by this commit  3.6.6
Revision:462016
brnrd search for other commits by this committer
security/openssl-devel: Mark broken databases cat
19 Sep 2017 10:42:07
Original commit files touched by this commit  3.6.6
Revision:450112
tz search for other commits by this committer
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
Original commit files touched by this commit  3.6.4
Revision:441053
antoine search for other commits by this committer
Fix PKGBASE collision with databases/pgpool
16 May 2017 10:57:49
Original commit files touched by this commit  3.6.4
Revision:440995
tz search for other commits by this committer
New port: databases/pgpool-II-36

This is an repo-copy of databases/pgpool-II-35 updated to 3.6.4

PR: 206839

Number of commits found: 23

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

14 vulnerabilities affecting 165 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-25 19:05:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39455
Broken 80
Deprecated 625
Ignore 370
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 19
Set to expire 580
Interactive 0
new 24 hours 4
new 48 hours7
new 7 days40
new fortnight83
new month243

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.