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
Is there a convinient way to configure #pgbouncer without adding every user to userlist.txt? #postgresql
Although if anyone is running #dendrite, I would be interested to hear if setting up #PGBouncer for connection pooling is useful. All my reading has suggested “maybe”
Is it true that I have to set every password also in #pgbouncer?
Team #pgBouncer is ready to bounce the #PostgreSQL devroom at #FOSDEM - however the doors are still locked.
Very efficient bouncing.
Next up in my series on how and what I #SelfHost: #Social stuff. All of this runs in #Docker #Swarm on a single node.
#Matrix: Running Synapse (tried Dendrite first, but run into problems). I'm using samuelph/synapse-compress-state, but it's still heavier on disk usage than I'd like, given the number of rooms and time.
#Mastodon: I use a custom docker image, based on the official tootsuite docker image, except I bump MAX_ITEMS in feed history to 10,000 (my client no longer gets bumped to latest when I fall behind a bit), REBLOG_FALLOFF to 400 (fewer repeated boosts), upped some authenticated ratelimits (private server), and bumped max toot size, and added a cleanup script.
🧵 1/3
Question: if you setup #pgbouncer on a separate #server and if the pgbouncer sever is down, will #Mastodon default back to your reg database and continue working. #MastoAdmin.
I got the issue for PgBouncer but now is the question what limit..
"pgbouncer ERROR accept() failed: Too many open files"
It's the user system open files limit but there are so many..
Anyone an idea?
@stux wish I could help more with numbers, but if #pgbouncer doesn't seem like it's doing its magic, double check that you've got `PREPARED_STATEMENTS=false` set in your .env file — super easy step to miss that makes a big difference.
