Dimitri Fontaine: Zero-downtime Postgres upgrades with logical replication

Dimitri Fontaine: Zero-downtime Postgres upgrades with logical replication
Align database expenses with actual business demand.
Is your engineering team still using fixed-size database setups in the cloud? How do you manage dynamic scaling?
PGConf Asia 2026 is heading to Hong Kong, from November 17–18. EDB's Bruce Momjian is serving on the organizing committee and co-chairing the program committee. Here is a sneak peek at the EDB-led sessions at PGConf Asia: www.enterprisedb.com/blog/confere... #PostgreSQL
Cloud is a way of working, not just a location.
Managing cloud databases like static on-premises hardware means paying for fixed compute capacity even when traffic drops.
pREST turns PostgreSQL tables into REST resources and a read-only MCP endpoint, without hand-writing a backend. Built by prest for developers exposing database data to agents. #PostgreSQL #MCP #Go
あたしが嫌なのは、アプリの「読み取り専用」がDBの権限まで下げてくれた気にさせること。SQLの文字列検査は抜けることがある。接続ロールの権限は必要な範囲に絞り、使ってるなら1.1.7以降へ。
#MCP #PostgreSQL
Alexander Ioffe: Why is my Whale Query 1000x Slower in Prod? Databases hate skew, each hates it differently
Chris van Eijk: PostgreSQL row-level security for SaaS: what we measured
Chris van Eijk: Go, pgx and PostgreSQL row-level security, measured
Pgpool-II 4.7.3, 4.6.8, 4.5.13, 4.4.18 and 4.3.21 fix seven CVEs. Five are watchdog: arbitrary 32-bit writes, out-of-bounds array writes, stack corruption, a NULL dereference, and electing the watchdog leader of your choice.
In case you didn't know, we have a YouTube channel! Many of our past Meetups have been recorded and can be watched at any time! Take a look:
The Boston PostgreSQL Users Group will be hosting its next event this Wednesday, October 14th! Join them for “Global Replication with Postgres & Postgres 19 REPACK”! RSVP’s close tomorrow, October 13th:
PGX is looking forward to tomorrow’s SF PUG! Our very own Christophe Pettus will be talking about “What's New in Postgres 19”. We hope you’ll join us!
🚨It’s tomorrow! 🚨Join us at Noon PDT for “What’s New in Postgres 19” with Christophe Pettus! RSVP now! 🐘