databases/pgpool-II-42 4.2.12 DragonFly

Connection pool server for PostgreSQL

System: DragonFly
Repository: DPorts
Maintainer: [email protected] (as in FreeBSD)
License: MIT
Categories: databases
Package size: 1293.3 KiB, 8393.6 KiB installed

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.

Install

Binary package:

pkg install pgpool-II42

From DPorts:

cd /usr/dports/databases/pgpool-II-42 && make install clean

Dependencies

Run dependencies 2

No port depends on this one.

Configuration

No options to configure.

Service scripts: none

Message after 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.

===>   NOTICE:

This port is deprecated; you may wish to reconsider installing it:

Upstream EOL reaches on 2025-11-30.

It is scheduled to be removed on or after 2025-12-31.