DEV Community

Dimitrios Desyllas
Dimitrios Desyllas

Posted on

How I can load balance Postgresql read connections?

As I asked upon https://dba.stackexchange.com/q/285811/118215

I am looking for an reverse-proxy implementation in order to load balance any read postgresql connection. I want during load balance to retrieve information regarding CPU usage and use the least used Database.

Can you suggest me an already implemented load-balancer for postgresql?

Top comments (2)

Collapse
 
martineboh profile image
Martin Eboh

Have you tried PGBouncer?

Collapse
 
pcmagas profile image
Dimitrios Desyllas

No, have you used it? What's your opinion on that? Can you provide me a use case?

Tiger Data image

🐯 🚀 Timescale is now TigerData: Building the Modern PostgreSQL for the Analytical and Agentic Era

We’ve quietly evolved from a time-series database into the modern PostgreSQL for today’s and tomorrow’s computing, built for performance, scale, and the agentic future.

So we’re changing our name: from Timescale to TigerData. Not to change who we are, but to reflect who we’ve become. TigerData is bold, fast, and built to power the next era of software.

Read more

👋 Kindness is contagious

Dive into this thoughtful piece, beloved in the supportive DEV Community. Coders of every background are invited to share and elevate our collective know-how.

A sincere "thank you" can brighten someone's day—leave your appreciation below!

On DEV, sharing knowledge smooths our journey and tightens our community bonds. Enjoyed this? A quick thank you to the author is hugely appreciated.

Okay