notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
pgpool Connection pool server for PostgreSQL
3.4.24 databases on this many watch lists=5 search for ports that depend on this port Find issues related to this port Report an issue related to this port
3.4.24Version of this port present on the latest quarterly branch.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2005-11-03 12:46:04
Last Update: 2019-05-17 09:30:16
SVN Revision: 501841
License: MIT
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 : Homepage
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (38 items)
  1. /usr/local/share/licenses/pgpool-3.4.24/catalog.mk
  2. /usr/local/share/licenses/pgpool-3.4.24/LICENSE
  3. /usr/local/share/licenses/pgpool-3.4.24/MIT
  4. bin/pcp_attach_node
  5. bin/pcp_detach_node
  6. bin/pcp_node_count
  7. bin/pcp_node_info
  8. bin/pcp_pool_status
  9. bin/pcp_proc_count
  10. bin/pcp_proc_info
  11. bin/pcp_promote_node
  12. bin/pcp_recovery_node
  13. bin/pcp_stop_pgpool
  14. bin/pcp_systemdb_info
  15. bin/pcp_watchdog_info
  16. bin/pg_md5
  17. bin/pgpool
  18. @sample etc/pcp.conf.sample
  19. @sample etc/pgpool.conf.sample
  20. etc/pgpool.conf.sample-master-slave
  21. etc/pgpool.conf.sample-replication
  22. etc/pgpool.conf.sample-stream
  23. @sample etc/pool_hba.conf.sample
  24. include/libpcp_ext.h
  25. include/pcp.h
  26. include/pool_process_reporting.h
  27. include/pool_type.h
  28. lib/libpcp.a
  29. lib/libpcp.so
  30. lib/libpcp.so.0
  31. lib/libpcp.so.0.0.0
  32. man/man8/pgpool.8.gz
  33. share/pgpool-II/insert_lock.sql
  34. share/pgpool-II/pgpool.pam
  35. share/pgpool-II/system_db.sql
  36. @dir /var/run/pgpool
  37. @postexec /usr/sbin/service ldconfig restart > /dev/null
  38. @postunexec /usr/sbin/service ldconfig restart > /dev/null
  39. Collapse this list.
Dependency lines:
  • pgpool>0:databases/pgpool
  • libpcp.so:databases/pgpool
Conflicts:
  • CONFLICTS:
    • pgpool-II-*
Conflicts Matches:
    There are no Conflicts Matches for this port. This is usually an error.

To install the port: cd /usr/ports/databases/pgpool/ && make install clean
To add the package: pkg install pgpool

PKGNAME: pgpool

There is no flavor information for this port.

distinfo:

TIMESTAMP = 1558014223
SHA256 (pgpool-II-3.4.24.tar.gz) = be4ca23e77ebb70fe06e83dc1d6ab80839be612913720962f103523eb38f735e
SIZE (pgpool-II-3.4.24.tar.gz) = 2184878


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/postgresql95-client
There are no ports dependent upon this port

Configuration Options
===> The following configuration options are available for pgpool-3.4.24:
     DOCS=on: Build and/or install documentation
     SSL=on: SSL protocol support
===> Use 'make config' to modify these settings

USES:
gmake libtool pgsql:9.3+ ssl

pkg-message:
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:
  1. http://www.pgpool.net/mediawiki/images/
Port Moves
  • port moved here from databases/pgpool-II on 2017-06-25
    REASON: Has expired: Deprecated by upstream; use database/pgpool instead

  • port moved here from databases/pgpool-II-30 on 2017-06-25
    REASON: Has expired: Deprecated by upstream; use database/pgpool instead

  • port moved here from databases/pgpool-II-22 on 2017-04-14
    REASON: Has expired: Deprecated by upstream; use database/pgpool instead

  • port moved here from databases/pgpool-II-23 on 2017-04-14
    REASON: Has expired: Deprecated by upstream; use database/pgpool instead

Number of commits found: 52

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
17 May 2019 08:30:16
Original commit files touched by this commit  3.4.24
Revision:501841
tz search for other commits by this committer
databases/pgpool: Upgrade from 3.4.23 to 3.4.24

Changelog:

  Enhancements

    - 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)

  Bug fixes

    - Fix the wrong error message "ERROR: connection cache is full", when all
backend nodes are down. (bug 487) (Bo Peng)
    - 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)
    - The error occurred while processing error message returned from backend
and the cause is that the query string in question is too big. Problem is, the
buffer is in fixed size (8192 bytes). Eliminate the fixed size buffer and use
palloced buffer instead. This also saves some memory copy work.
    - Fix DROP DATABASE failure. (Tatsuo Ishii)
    - Fix wrong variable in read_status_file() function. (bug 493) (Takuma
Hoshiai)
    - Fix compiler warnings. (Tatsuo Ishii)

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-4-24.html
08 Apr 2019 07:05:33
Original commit files touched by this commit  3.4.23
Revision:498348
tz search for other commits by this committer
databases/pgpool: Update from 3.4.22 to 3.4.23

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)

      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-4-23.html

MFH:		2019Q2
08 Mar 2019 15:51:22
Original commit files touched by this commit  3.4.22
Revision:495048
tz search for other commits by this committer
databases/pgpool: Upgrade from 3.4.21 to 3.4.22

Changelog:
- 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)
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection.
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on.

MFH:		2019Q1
12 Dec 2018 01:35:36
Original commit files touched by this commit  3.4.21_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:33:54
Original commit files touched by this commit  3.4.21
Revision:485994
tz search for other commits by this committer
databases/pgpool: Upgrade from 3.4.20 to 3.4.21

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-21.html
22 Nov 2018 09:32:45
Original commit files touched by this commit  3.4.20
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.4.20
Revision:485055
joneum search for other commits by this committer
Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
15 Nov 2018 21:46:56
Original commit files touched by this commit  3.4.20
Revision:485051
joneum search for other commits by this committer
Update to 3.4.20

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-20.html

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
10 Nov 2018 10:09:49
Original commit files touched by this commit  3.4.19
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:14:08
Original commit files touched by this commit  3.4.19
Revision:475975
tz search for other commits by this committer
databases/pgpool: Update from 3.4.18 to 3.4.19

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-19.html
27 Jun 2018 11:01:41
Original commit files touched by this commit  3.4.18
Revision:473429
tz search for other commits by this committer
databases/pgpool: Update from 3.4.17 to 3.4.18

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-18.html
18 Apr 2018 12:27:38
Original commit files touched by this commit  3.4.17
Revision:467708
tz search for other commits by this committer
databases/pgpool: Update from 3.4.16 to 3.4.17

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-17.html
21 Feb 2018 10:56:48
Original commit files touched by this commit  3.4.16
Revision:462489
tz search for other commits by this committer
databases/pgpool: Upgrade from 3.4.11 to 3.4.16

Changelogs:
- http://www.pgpool.net/docs/latest/en/html/release-3-4-12.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-13.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-14.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-15.html
- http://www.pgpool.net/docs/latest/en/html/release-3-4-16.html
16 Feb 2018 17:52:50
Original commit files touched by this commit  3.4.11
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.4.11
Revision:462016
brnrd search for other commits by this committer
security/openssl-devel: Mark broken databases cat
16 May 2017 08:58:32
Original commit files touched by this commit  3.4.11
Revision:440992
tz search for other commits by this committer
databases/pgpool: Limit PORTSCOUT to 3.4.x

Future pgpool version of 3.5 and 3.6 will get an own port,
therefore limiting the PORTSCOUT check to actual branch

PR: 206839
15 May 2017 13:48:18
Original commit files touched by this commit  3.4.11
Revision:440927
tz search for other commits by this committer
databases/pgpool: Update from 3.4.9 to 3.4.11

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-10.html
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-11.html

PR: 206839
15 Mar 2017 14:45:55
Original commit files touched by this commit  3.4.9_1
Revision:436248
mat search for other commits by this committer
Remove all _USE=openssl occurrences.

Sponsored by:	Absolight
15 Mar 2017 08:58:11
Original commit files touched by this commit  3.4.9_1
Revision:436201
tz search for other commits by this committer
databases/pgpool: Add options DOCS and SSL

Reintegrate DOCS and SSL options already used in previous
versions in the ports-tree.

Submitted by: Adam Schumacher <adam.schumacher@flightaware.com>
02 Mar 2017 12:24:34
Original commit files touched by this commit  3.4.9
Revision:435231
tz search for other commits by this committer
databases/pgpool: Update from 3.4.3 to 3.4.9

Changelog: http://www.pgpool.net/docs/pgpool-II-3.4.8/NEWS.txt
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-4-9.html

PR:           206839
Submitted by: Felix Hanley <felix@userspace.com.au>
10 Jun 2016 09:08:02
Original commit files touched by this commit  3.4.3
Revision:416662
tz search for other commits by this committer
Change MAINTAINER from ports@toco-domains.de to tz@FreeBSD.org

Approved by:	junovitch (mentor)
15 Nov 2015 03:04:15
Original commit files touched by this commit  3.4.3
Revision:401664
amdmi3 search for other commits by this committer
- Add forgotten pkg-message

PR:		203769
Submitted by:	ports@toco-domains.de
15 Nov 2015 03:02:59
Original commit files touched by this commit  3.4.3
Revision:401653
amdmi3 search for other commits by this committer
- Update to 3.4.3
- Pass maintainership to submitter
- Update MASTERSITE and www
- Strip library

PR:		203769
Submitted by:	ports@toco-domains.de
06 Dec 2014 22:24:47
Original commit files touched by this commit  3.4.1_1
Revision:374161
feld search for other commits by this committer
The pgpool license is actually an old minimal variant of the MIT license

Submitted by:	antoine
05 Dec 2014 00:30:20
Original commit files touched by this commit  3.4.1_1
Revision:373992
feld search for other commits by this committer
Update "BSD" licenses in databases category
20 Oct 2014 10:41:13
Original commit files touched by this commit  3.4.1_1
Revision:371255
bapt search for other commits by this committer
Cleanup plist
03 Jul 2014 21:48:44
Original commit files touched by this commit  3.4.1_1
Revision:360463  Sanity Test Failure
adamw search for other commits by this committer
Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations.
13 Jun 2014 15:46:53
Original commit files touched by this commit  3.4.1_1
Revision:357694
vanilla search for other commits by this committer
Stagify.

Approved by:	portmgr@
10 Jun 2014 07:39:02
Original commit files touched by this commit  3.4.1_1
Revision:357277
olgeni search for other commits by this committer
Remove indefinite articles and trailing periods from COMMENT, plus
minor COMMENT typos and surrounding whitespace fixes. Categories D-F.

CR:		D196
Approved by:	portmgr (bapt)
26 May 2014 11:57:56
Original commit files touched by this commit  3.4.1_1
Revision:355309
miwi search for other commits by this committer
- Convert gmake, bzip to USES

Approved by:	portmgr
21 Jan 2014 23:18:05
Original commit files touched by this commit  3.4.1_1
Revision:340671
bapt search for other commits by this committer
Fix properties on pkg-plist
20 Sep 2013 16:13:49
Original commit files touched by this commit  3.4.1_1
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
28 Mar 2013 16:29:01
Original commit files touched by this commit  3.4.1_1
Revision:315487
eadler search for other commits by this committer
Style: tab -> space.

Most contributors copy an existing port when writing their own so reduce the
number of bad examples in the tree.
14 Jan 2012 08:57:23
Original commit files touched by this commit  3.4.1_1

dougb search for other commits by this committer
In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().

In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.
20 Mar 2011 12:54:45
Original commit files touched by this commit  3.4.1_1

miwi search for other commits by this committer
- Get Rid MD5 support
13 Oct 2010 11:49:12
Original commit files touched by this commit  3.4.1_1

kuriyama search for other commits by this committer
- Upgrade to 3.0 after repocopied to pgpool-II-23.

PR:             ports/150907
Submitted by:   Mikhail Tsatsenko <m.tsatsenko@mail.ru>
27 Mar 2010 00:15:24
Original commit files touched by this commit  3.4.1_1

dougb search for other commits by this committer
Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr#
28 Mar 2008 00:31:18
Original commit files touched by this commit  3.4.1_1

pav search for other commits by this committer
- Fix plist

Pointy hat to:  nork
22 Mar 2008 16:29:37
Original commit files touched by this commit  3.4.1

nork search for other commits by this committer
Fix MASTER_SITES.

Pointy hat to:  myself
17 Mar 2008 10:08:40
Original commit files touched by this commit  3.4.1

erwin search for other commits by this committer
Mark BROKEN: size mismatch.
05 Mar 2008 07:19:30
Original commit files touched by this commit  3.4.1

nork search for other commits by this committer
Update to 3.4.1.
16 Apr 2007 03:42:16
Original commit files touched by this commit  3.2_1

kuriyama search for other commits by this committer
- Add pgpool-II 1.0.2 after repocopy from databases/pgpool.
13 Feb 2007 08:54:28
Original commit files touched by this commit  3.2

nork search for other commits by this committer
Fix build on 4.x.

Obtained from:  PostgreSQL Japanese Mailing List
11 Feb 2007 03:35:13
Original commit files touched by this commit  3.2

nork search for other commits by this committer
Update to 3.2.
14 Dec 2006 22:19:07
Original commit files touched by this commit  3.1.2

miwi search for other commits by this committer
- Update to 3.1.2

PR:             ports/106668
Submitted by:   Robert Gogolok<gogo@cs.uni-sb.de>
Approved by:    maintainer
13 Dec 2006 12:56:01
Original commit files touched by this commit  3.1.1

linimon search for other commits by this committer
Reset whitekid@gmail.com after timeouts and no response to email.

Hat:            portmgr
07 Aug 2006 10:07:22
Original commit files touched by this commit  3.1.1

miwi search for other commits by this committer
- Update to 3.1.1

PR:             ports/100788
Submitted by:   Robert Gogolok <gogo(at)cs.uni-sb.de>
Approved by:    krion (mentor), maintainer timeout
14 Jul 2006 01:56:52
Original commit files touched by this commit  3.1

clsung search for other commits by this committer
- Update to version 3.1.

PR:             ports/100125
Submitted by:   Robert Gogolok <gogo_AT_cs dot uni-sb dot de>
Approved by:    maintainer (Choe, Cheng-Dae)
15 May 2006 09:14:34
Original commit files touched by this commit  3.0.1

lawrance search for other commits by this committer
Update to 3.0.1.
Run as 'nobody' rather than root.

PR:             ports/96637
Submitted by:   Vivek Khera <vivek@khera.org>
Approved by:    Choe, Cheng-Dae <whitekid@gmail.com> (maintainer)
14 Apr 2006 18:40:59
Original commit files touched by this commit  2.6.3_1

mnag search for other commits by this committer
- Add rc.d script.
- Bump PORTREVISION

PR:             94137
Submitted by:   Chris St Denis <chris___ctgameinfo.com>
Approved by:    maintainer timeout, 39 days
22 Jan 2006 08:23:41
Original commit files touched by this commit  2.6.3

edwin search for other commits by this committer
SHA256ify

Approved by:    krion@
03 Nov 2005 12:42:48
Original commit files touched by this commit  2.6.3

mnag search for other commits by this committer
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.projects.postgresql.org/

PR:             87701
Submitted by:   Choe, Cheng-Dae <whitekid@gmail.com>

Number of commits found: 52

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
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
zncJun 22
firefoxJun 21
firefox-esrJun 21
thunderbirdJun 21
thunderbirdJun 21
firefox*Jun 20
firefox-esr*Jun 20
vlcJun 20
vlcJun 20
waterfox*Jun 20
ImageMagick6*Jun 17
ImageMagick6-nox11*Jun 17
ImageMagick7*Jun 17
ImageMagick7-nox11*Jun 17
GraphicsMagickJun 16

16 vulnerabilities affecting 123 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-06-22 13:48:42


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36732
Broken 84
Deprecated 123
Ignore 306
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 32
Expired 14
Set to expire 93
Interactive 0
new 24 hours 3
new 48 hours7
new 7 days34
new fortnight68
new month156

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