#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.
-
Как построить отказоустойчивый 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
-
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
-
📣 @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/
-
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.
💜💜💜