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.
===> The following configuration options are available for pgpool-II41-4.1.17:
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
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.
all: drop support for expired FreeBSD 14.0
Simplify expressions for FreeBSD 13.X
Reviewed by: many
Differential Revision: https://reviews.freebsd.org/D46601
databases/pgpool-II-41: Extend EXPIRATION_DATE
The EOL for the branch has been extended so extend the DEPRECATION and
EXPIRATION_DATE accordingly.
See:
https://www.pgpool.net/mediawiki/index.php/EOL_information
Approved by: portmgr (blanket)
*/*: llvm15 build fixes
llvm15 was also merged into 13.2-STABLE effective from OSVERSION
1302505. Fix the ports that failed to build with llvm15.
Approved by: portmgr (blanket)
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
*/*: 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)
databases/pgpool-II-41: Update version 4.1.2=>4.1.6
- Pet portlint
- Fix pkg-plist. Except the default pgpool.conf.sample other
pgpool.conf.sample* represents different configurations for different
scenario. Only the pgpool.conf.sample should create a corresponding
pgpool.conf file. Hence removing the @sample directive for the other
pgpool.conf.sample*
Approved by: tz
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-6.html
Sponsored by: Bounce Experts
Differential Revision: https://reviews.freebsd.org/D30177
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>
