notbugIf you buy from Amazon USA, please support us by using this link.
Port details
pgpool-II-40 Connection pool server for PostgreSQL
4.0.2_2 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2018-11-15 21:06:40
Last Update: 2019-01-17 11:15:44
SVN Revision: 490545
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 : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (40 items)
  1. /usr/local/share/licenses/pgpool-II40-4.0.2_2/catalog.mk
  2. /usr/local/share/licenses/pgpool-II40-4.0.2_2/LICENSE
  3. /usr/local/share/licenses/pgpool-II40-4.0.2_2/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_watchdog_info
  15. bin/pg_enc
  16. bin/pg_md5
  17. bin/pgpool
  18. bin/pgpool_setup
  19. bin/pgproto
  20. bin/watchdog_setup
  21. @sample etc/pcp.conf.sample
  22. @sample etc/pgpool.conf.sample
  23. etc/pgpool.conf.sample-logical
  24. etc/pgpool.conf.sample-master-slave
  25. etc/pgpool.conf.sample-replication
  26. etc/pgpool.conf.sample-stream
  27. @sample etc/pool_hba.conf.sample
  28. include/libpcp_ext.h
  29. include/pcp.h
  30. include/pool_process_reporting.h
  31. include/pool_type.h
  32. lib/libpcp.a
  33. lib/libpcp.so
  34. lib/libpcp.so.1
  35. lib/libpcp.so.1.0.0
  36. share/pgpool-II/insert_lock.sql
  37. share/pgpool-II/pgpool.pam
  38. @dir /var/run/pgpool
  39. @postexec /usr/sbin/service ldconfig restart > /dev/null
  40. @postunexec /usr/sbin/service ldconfig restart > /dev/null
  41. Collapse this list.

Dependency line: pgpool-II40>0:databases/pgpool-II-40

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-40/ && make install clean
To add the package: pkg install pgpool-II40

PKGNAME: pgpool-II40

There is no flavor information for this port.

distinfo:

TIMESTAMP = 1543230542
SHA256 (pgpool-II-4.0.2.tar.gz) = a9324dc84e63961476cd32e74e66b6fdebc5ec593942f8710a688eb88e50dcc1
SIZE (pgpool-II-4.0.2.tar.gz) = 3576212


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

Configuration Options
===> The following configuration options are available for pgpool-II40-4.0.2_2:
     DOCS=on: Build and/or install documentation
     MEMCACHED=off: Use memcached for in memory query cache
     PAM=off: Build with PAM support
     SSL=on: Build with OpenSSL support
===> Use 'make config' to modify these settings

USES:
gmake libtool pgsql:9.6+ 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/

Number of commits found: 7

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
17 Jan 2019 11:15:44
Original commit files touched by this commit  4.0.2_2
Revision:490545
tobik search for other commits by this committer
databases/pgpool-II-40: Actually unbreak PAM option after r490475

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)
16 Jan 2019 12:03:14
Original commit files touched by this commit  4.0.2_2
Revision:490475
tobik search for other commits by this committer
databases/pgpool-II-40: Unbreak PAM option

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)
12 Dec 2018 01:35:36
Original commit files touched by this commit  4.0.2_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:36:59
Original commit files touched by this commit  4.0.2
Revision:485998
tz search for other commits by this committer
databases/pgpool-II-40: Upgrade from 4.0.1 to 4.0.2

Changelog: http://www.pgpool.net/docs/latest/en/html/release-4-0-2.html
22 Nov 2018 09:18:32
Original commit files touched by this commit  4.0.1
Revision:485584
tobik search for other commits by this committer
databases/pgpool-II-40: Drop incorrect BROKEN_SSL

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
15 Nov 2018 22:09:04
Original commit files touched by this commit  4.0.1
Revision:485055
joneum search for other commits by this committer
Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
15 Nov 2018 21:06:27
Original commit files touched by this commit  4.0.1
Revision:485048
joneum search for other commits by this committer
New Port: databases/pgpool-II-40

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

Number of commits found: 7

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, 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
joomla3Jan 20
drupal7Jan 19
drupal8Jan 19
helmJan 18
gitlab-ceJan 17
jenkinsJan 16
jenkins-ltsJan 16
py-matrix-synapseJan 15
irssiJan 10
giteaJan 06
uriparserJan 06
chromiumJan 05
chromiumJan 05
openjpeg*Jan 05
py-django111Jan 05

9 vulnerabilities affecting 54 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-01-20 01:05:52


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36024
Broken 120
Deprecated 412
Ignore 334
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 34
Expired 5
Set to expire 385
Interactive 0
new 24 hours 5
new 48 hours6
new 7 days39
new fortnight67
new month160

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