Hi folks, in this blog, we are going to take a look into query routing and rewrite pgbouncer-rr setup for PostgreSQL using Python.
If you are new to Pgbouncer-rr concept, please refer to this blog.
Below is a brief introduction to pgbouncer-rr.
Note: rr stands for Routing and Rewriting.
Route: It sends queries to different server from one client connection.
Rewrite: We can change or alter the client query programmatically.
We are using python for routing and…