pgpool-II-41 Connection pool server for PostgreSQL

4.1.1 databases =1 4.1.1Version of this port present on the latest quarterly branch.

Maintainer: tz@FreeBSD.org

Port Added: 2020-03-29 21:55:55

Last Update: 2020-03-29 22:48:13

SVN Revision: 529842

People watching this port, also watch: nfs-ganesha, 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 : Homepage

pkg-plist: as obtained via: make generate-plist

Expand this list (45 items)

1. @ldconfig
2. /usr/local/share/licenses/pgpool-II41-4.1.1/catalog.mk
3. /usr/local/share/licenses/pgpool-II41-4.1.1/LICENSE
4. /usr/local/share/licenses/pgpool-II41-4.1.1/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_enc
17. bin/pg_md5
18. bin/pgpool
19. bin/pgpool_setup
20. bin/pgproto
21. bin/watchdog_setup
22. @sample etc/failover.sh.sample
23. @sample etc/follow_master.sh.sample
24. @sample etc/pcp.conf.sample
25. @sample etc/pgpool.conf.sample
26. @sample etc/pgpool.conf.sample-logical
27. @sample etc/pgpool.conf.sample-master-slave
28. @sample etc/pgpool.conf.sample-replication
29. @sample etc/pgpool.conf.sample-stream
30. @sample etc/pgpool_remote_start.sample
31. @sample etc/pool_hba.conf.sample
32. etc/rc.d/pgpool
33. etc/recovery_1st_stage.sample
34. etc/recovery_2nd_stage.sample
35. include/libpcp_ext.h
36. include/pcp.h
37. include/pool_process_reporting.h
38. include/pool_type.h
39. lib/libpcp.a
40. lib/libpcp.so
41. lib/libpcp.so.1
42. lib/libpcp.so.1.0.0
43. share/pgpool-II/insert_lock.sql
44. share/pgpool-II/pgpool.pam
45. @dir /var/run/pgpool

Collapse this list.

Dependency lines:

• pgpool-II41>0:databases/pgpool-II-41

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-41/ && make install clean

To add the package: pkg install pgpool-II41

PKGNAME: pgpool-II41

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1583510780 SHA256 (pgpool-II-4.1.1.tar.gz) = b6e334984aeed36e1a882266e65963dd0f5145d19bc0b30019c0b566dce33b61 SIZE (pgpool-II-4.1.1.tar.gz) = 4238410

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

===> The following configuration options are available for pgpool-II41-4.1.1: 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:

If installing:

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/

New port: databases/pgpool-II-41

Repocopy databases/pgpool-II-40 and modify it to introduce
new pgpool version 4.1.x.

Major enhancements in Pgpool-II 4.1 include:

    * Statement level load balancing.
    * Auto failback.
    * Enhance performance in number of areas.
        * Shared relation cache allows to reuse relation cache among sessions to
reduce internal queries against PostgreSQL system catalogs.
        * Have separate SQL parser for DML statements to eliminate unnecessary
parsing effort.
        * Load balancing control for specific queries.
    * Reduce Internal Queries against System Catalogs.
    * Import PostgreSQL 12 SQL parser.

PR:		244646
Submitted by:	Franko Ricci <franco.ricc@gmail.com>

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

^* - modified, not new

All vulnerabilities

Last updated:
2020-05-29 07:54:06