This Blog has moved from Medium to All the latest content will be available there. Subscribe to our newsletter to stay updated.

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…

Akash Srinivasan

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store