#pgbouncer — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #pgbouncer, aggregated by home.social.
-
I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073
Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.
The problem is that no matter how hard I try to learn and write C, I fail.
I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.
I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.
You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.
-
I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073
Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.
The problem is that no matter how hard I try to learn and write C, I fail.
I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.
I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.
You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.
-
I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073
Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.
The problem is that no matter how hard I try to learn and write C, I fail.
I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.
I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.
You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.
-
I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073
Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.
The problem is that no matter how hard I try to learn and write C, I fail.
I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.
I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.
You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.
-
I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073
Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.
The problem is that no matter how hard I try to learn and write C, I fail.
I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.
I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.
You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.
-
Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться
В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.
https://habr.com/ru/companies/postgrespro/articles/1004040/
#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon
-
Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться
В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.
https://habr.com/ru/companies/postgrespro/articles/1004040/
#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon
-
Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться
В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.
https://habr.com/ru/companies/postgrespro/articles/1004040/
#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon
-
Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться
В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.
https://habr.com/ru/companies/postgrespro/articles/1004040/
#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon
-
Когда стойка умирает, а 5xx остаётся нулевым. Разбор скрытой деградации PostgreSQL
09:12 — db-replica-02 connection timeout HTTP 5xx = 0.2% HAProxy зелёный p50 = 38-42ms Replica в другой стойке недоступна Отказоустойчивость потеряна Инцидент не объявлен Читать разбор
https://habr.com/ru/articles/1002056/
#PostgreSQL #отказоустойчивость #деградация #retry #HAProxy #PgBouncer #ToR #инцидент #latency #SRE
-
Когда стойка умирает, а 5xx остаётся нулевым. Разбор скрытой деградации PostgreSQL
09:12 — db-replica-02 connection timeout HTTP 5xx = 0.2% HAProxy зелёный p50 = 38-42ms Replica в другой стойке недоступна Отказоустойчивость потеряна Инцидент не объявлен Читать разбор
https://habr.com/ru/articles/1002056/
#PostgreSQL #отказоустойчивость #деградация #retry #HAProxy #PgBouncer #ToR #инцидент #latency #SRE
-
Когда стойка умирает, а 5xx остаётся нулевым. Разбор скрытой деградации PostgreSQL
09:12 — db-replica-02 connection timeout HTTP 5xx = 0.2% HAProxy зелёный p50 = 38-42ms Replica в другой стойке недоступна Отказоустойчивость потеряна Инцидент не объявлен Читать разбор
https://habr.com/ru/articles/1002056/
#PostgreSQL #отказоустойчивость #деградация #retry #HAProxy #PgBouncer #ToR #инцидент #latency #SRE
-
Когда стойка умирает, а 5xx остаётся нулевым. Разбор скрытой деградации PostgreSQL
09:12 — db-replica-02 connection timeout HTTP 5xx = 0.2% HAProxy зелёный p50 = 38-42ms Replica в другой стойке недоступна Отказоустойчивость потеряна Инцидент не объявлен Читать разбор
https://habr.com/ru/articles/1002056/
#PostgreSQL #отказоустойчивость #деградация #retry #HAProxy #PgBouncer #ToR #инцидент #latency #SRE
-
CloudNativePG versions 1.28.1 and 1.27.3 released, delivering important bug fixes and stability improvements:
1️⃣ Critical fix for #PgBouncer upgrades
2️⃣ Timeline protection during WAL restore
3️⃣ Timeline reset after major upgrades
https://cloudnative-pg.io/releases/cloudnative-pg-1-28.1-released/ #PostgreSQL #Kubernetes -
Spent most of the afternoon tuning #Postgresql and bits of #Mastodon
Looked at #PGBouncer, but I don't think I need it (yet)
-
Fuzzing PostgreSQL at the front door 🔍
Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/
#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools
-
Fuzzing PostgreSQL at the front door 🔍
Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/
#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools
-
Fuzzing PostgreSQL at the front door 🔍
Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/
#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools
-
Fuzzing PostgreSQL at the front door 🔍
Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/
#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools
-
Fuzzing PostgreSQL at the front door 🔍
Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/
#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools
-
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!
#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
-
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!
#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
-
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!
#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
-
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!
#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
-
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!
#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.
🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance
-
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/
-
📣 @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 #MicrosoftEnjoy! https://www.citusdata.com/blog/2024/04/04/pgbouncer-supports-more-session-vars/
-
Wait...what? #pgbouncer gets support for prepared statements? Niiiiice.
-
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