#TIL #pgbouncer has two sets of #certificates related config: one for the service it provides, which, because it's facing clients, are called `client_*`; the ones the service uses, as a #postgres client, to validate upstream servers, are called `server_*`. This, mixed with an internal doc that says "a client certificate that authenticates the [cloud service] to connect to pgbouncer" led me to not understanding anyshit anymore. Worse, for some reason `openssl s_connect` was not finding a cert.
#pgbouncer
Best Open Source Tools For PostgreSQL
What is PostgreSQL? PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform. PostgreSQL has earned a strong reputation for its proven architecture, […]https://www.simplyblock.io/blog/best-open-source-tools-for-postgresql/
使用 PgBouncer (pool)的時候會造成 side cursors 要關掉
```
# psycopg server-side cursors conflict with ATOMIC_REQUESTS wrapping admin views
# and can raise InvalidCursorName when the transaction closes mid-iteration.
# https://docs.djangoproject.com/en/5.2/ref/databases/#transaction-pooling-server-side-cursors
# We using PgBouncer at prodcution
DATABASES["default"]["DISABLE_SERVER_SIDE_CURSORS"] = True
```
𝗣𝗴𝗕𝗼𝘂𝗻𝗰𝗲𝗿 𝟭.𝟮𝟯.𝟭 is now GA on #AzureDBPostgres
Built-in connection pooling with zero setup. Just enable port 6432 and scale with ease. Now with enhanced protocol handling + stability fixes.
🔗 https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-pgbouncer
anybody wanna recommend me a favorite GUI way of remotely managing a #Postgres server (you know, create/delete databases, database users etc) which doesn't involve me vastly increasing the attack surface of said server?
major bonus points if it has any awareness / ability to deal with #PgBouncer.
[Blog] Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose: https://www.sqlpassion.at/archive/2025/09/01/running-postgresql-with-pgbouncer-on-macos-using-docker-compose/ #postgres #PostgreSQL #pgbouncer #Docker
📣 @pgdaylowlands is almost here! On Sept 11 we'll kick things off with a warm-up meetup 🎉🍕🍻
I'll be talking about scaling #PgBouncer ⚡ Why its single threaded design can hold you back, and how to fix it with real configuration examples and lessons learned from the field 🔧:postgresql:
If you're a #PostgreSQL enthusiast, come join us for an evening full of community vibes 🚀✨ Big thanks to the organizing team 🙌
#PGDayLowlands #PostgresCommunity #OpenSource #TechMeetup
https://www.meetup.com/postgresql-user-group-nl/events/310728717/
#PgBouncer is useful, important, and fraught with peril
Watch how you can diagnose incidents in seconds using #opensource, #eBPF-powered observability. 👇🐧 🐝
Track all communications between cluster components such as #Patroni, #Postgres, #Pgbouncer, and the #Kubernetes API server: https://github.com/coroot/coroot
Работа с базой данных для джунов и вайбкодеров. Соединения
Коннекты обычно не приносят много головной боли на начальных этапах разработки. Вообще работа с ними обычно делается один раз, во время настройки, и дальше тюнится по необходимости. Но эта необходимость возникает часто в виде непонятных ошибок, которые выкидываются в случайных местах, непонятных графиков в графане и суеты админов вашей базы данных. Я постарался собрать ту информацию, которая позволит вам не потеряться в такой ситуации и даже поможет определить суть проблемы.
https://habr.com/ru/articles/908376/
#базы_данных #коннекты #баги #коннект_к_бд #пул_соединений #hikaricp #hikaripool #pgbouncer
Volunteering for Hachyderm is a breath of fresh air to me.
On the technical side, creating and adding Ansible roles for PostgreSQL (including PgBouncer and pgBackRest) is fun. I'm learning a lot, even with more than 10 years of experience.
On the human side, I'm honoured to be part of such an amazing worldwide team sharing the same values.
💜💜💜
Such a privilege to work with #PostgreSQL & #PgBouncer & Citus contributor Jelte Fennema-Nio from the team at Microsoft… who was on stage today at #PGConfdev giving a super cool talk (where Jelte told us what he really thinks) about “The Postgres Protocol: The Good, The Bad and The Future”
#conference #OpenSource #Postgres #Microsoft #database
Enjoyed collaborating with Postgres & PgBouncer engineer Emel Simsek who works in the PG team at Microsoft, on her first-ever blog post, published on the Citus Open Source Blog
... about the new support in PgBouncer 1.20.0 for Session vars
(#PgBouncer is one of the more popular connection poolers for #PostgreSQL)
#database #Citus #OpenSource #Microsoft
Enjoy! https://www.citusdata.com/blog/2024/04/04/pgbouncer-supports-more-session-vars/
Wait...what? #pgbouncer gets support for prepared statements? Niiiiice.
A tip for fellow #MastoAdmin : During the update I ran into a bug with the latest pgbouncer image (1.20.1), it would overwrite the userlist.txt causing pgbouncer being unable to login and thus Mastodon to fail.
If you use #pgbouncer , make sure to specify version 1.20.0 for now. See https://github.com/bitnami/containers/issues/48264
Great article on how to work with pgbouncer and postgres.
https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html
🌘 PgBouncer是有用的，重要的，但也充滿危險 - JP Camara
➤ 什麼是連接池？為什麼需要連接池？如何使用PgBouncer實現連接池？
✤ https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html
本文介紹了什麼是連接池，為什麼需要連接池，以及如何使用PgBouncer來實現連接池。作者提到，PgBouncer雖然是PostgreSQL的一個常見的連接池解決方案，但它也存在一些危險性，需要注意。作者還列舉了一些PgBouncer無法支持的PostgreSQL功能，以及如何在不使用連接池的情況下改進連接性能。
+ 很好的一篇文章，讓我對PgBouncer有了更深入的瞭解。
+ 作者提到了一些PgBouncer無法支持的PostgreSQL功能，這對我來說非常有幫助。
#PostgreSQL #PgBouncer #連接池
New episode: "Connection poolers"
Nikolay and Michael discuss #Postgres connection poolers — when and why we need them, the king that is #PgBouncer, and the many new pretenders to the throne.
🎙️ https://postgres.fm/episodes/connection-poolers
Ok, what a fucking mess. Seems something changed or something is different now, but:
pgbouncer auth user must have md5 password set and md5 allowed to use for this user only. then logins will work with the SCRAM passwords for the normal users. Meh. what a gagsi #PostgreSQL #PGbouncer
Well then, time for me to replace #pgbouncer with #supabase #supavisor 😁
https://github.com/supabase/supavisor
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst