How should you split Postgres database queries?

Question

PostgreSQL

There is a Postgres cluster of 7 servers (6 slaves, 1 master) managed by patroni. What is the best way to separate requests to the database for reading / writing - hang HAProxy and make 2 ports - one read-write (master), and the other - read-only (slave), or use pgbouncer / pgpool?

Answer 1

Consider using Odyssey as a connection pooler https://github.com/yandex/odyssey
A pooler will definitely not hurt.
We define trips to read-only replicas at the application level.