O
O
Oleg Tarakanov2017-09-25 10:21:02
PostgreSQL
Oleg Tarakanov, 2017-09-25 10:21:02

How to configure pgpool2 to only balance requests?

Good afternoon!
The task is to organize a cluster with the following scheme:
5 x postgres + repmgr (WAL repl) => pgpool (select load balance) => pgboucer (pool connection)
I could not accumulate comprehensive information on the pgpool configuration in such a way that it:
1. balances select requests between all nodes;
2. monitored the primary-server and sent requests for changing/introducing data to it;
3. did not try to act as a failover manager, because repmgr does this.
I honestly tried to read the documentation, smoke instances, but did not find an unambiguous solution.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question