pcp_recovery_node

connection pool server and replication proxy for PostgreSQL

Install

All systems
curl cmd.cat/pcp_recovery_node.sh
Debian Debian
apt-get install pgpool2
Ubuntu
apt-get install pgpool2
image/svg+xml Kali Linux
apt-get install pgpool2
Fedora
dnf install postgresql-pgpool-II
Windows (WSL2)
sudo apt-get update sudo apt-get install pgpool2
Raspbian
apt-get install pgpool2

pgpool2

connection pool server and replication proxy for PostgreSQL

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It provides the following features: * Connection Pooling * Replication * Load Balance * Limiting Exceeding Connections * Parallel Query pgpool-II talks PostgreSQL's backend and frontend protocol, and relays a connection between them. Therefore, a database application (frontend) thinks that pgpool-II is the actual PostgreSQL server, and the server (backend) sees pgpool-II as one of its clients. Because pgpool-II is transparent to both the server and the client, an existing database application can be used with pgpool-II almost without a change to its sources. This is version 3 of pgpool-II, the second generation of pgpool.

postgresql-pgpool-II

Pgpool is a connection