Take a look at “Getting Advice from Myself Using PGVector, RAG, Flat Files, and JSON_TABLEs” with Jay Miller at Pg Day Chicago 2025!

https://postgresql.us/events/pgdaychicago2025/sessions/session/1932-getting-advice-from-myself-using-pgvector-rag-flat-files-and-json_tables/

@PostgreSQL #postgres #conference

Some time ago I mentioned here, in half-joking way, self-fixing software I work with. I said Patroni #Postgres has the best regeneration ability I've ever seen. And currently "the best ability" includes:

> After network migrations servers changed IP addresses. It broke etcd config so I had to completely delete that config and initialize etcd cluster again. Which also forced cleaning and renewing Patroni config because it is strongly dependent on etcd. Even when configuration temporarily didn't exist, connection with WAL archives (technically other separate server) wasn't interrupted (I am not even sure if real data transfer could happen at that time). It was seemingly enough to start new #database cluster from last timeline. I don't know WHAT forced servers to immediately pull that data on fresh start. At migration time there weren't any real production data so I didn't even purposely try to restore anything.

> Not so long time later (and now with real production things) some script tests, causing lots of database changes in relatively short time, beyond former server's capacity, killed master server. Patroni switched as intended and I could work on increasing server's capacity (had to do it live, not very convenient). First server finally decided data corruption was too big and to fix it automatically deleted whole /var/lib/postgresql/* directory and started to recreate thing from scratch, using data from new master server (and was doing it with at least 2 GB/s speed because why not? ).

> During above mentioned process impatient tester hit again with their not optimised scripts, finally killing whole cluster. Swearing silently I increased remaining servers as it was only thing I really could do. Postgresql API mostly wasn't responsive, it had limited info about last state before final failure. It wasn't possible to force any change or affect it in any way.
First server decided to delete whole directory again and recreate it (at least this time I saw exact moment in logs), at the same time second server did rewind to state of third server (why??). All these things happened automatically, without my help. I wouldn't even know what to do

And it's only beginning when we use it on production. Now I wait for stubborn users to do some more unintended durability tests... Maybe I would see it's even more invincible

Pg Day Chicago’s presentations span a wide variety of topics surrounding PostgreSQL. The conference will run 2 parallel tracks covering different technical levels to ensure there is always something interesting for everybody!

https://2025.pgdaychicago.org/tickets/

@PostgreSQL #postgres #conference

Join us in 2 days, on Tuesday April 8th at noon PST for "Where do Performance Cliffs Come From?" with Tomas Vondra! RSVP today!

https://www.meetup.com/postgresql-1/events/306484787/?eventOrigin=group_events_list

@PostgreSQL #Postgres #meetup

Join us for “1 Billion Row Challenge: Comparing Postgres, DuckDB, and Extensions” with Ryan Booz at PgDay Chicago 2025!

https://postgresql.us/events/pgdaychicago2025/sessions/session/1925-1-billion-row-challenge-comparing-postgres-duckdb-and-extensions/

@PostgreSQL #postgres #conference

We want to be sure everyone who attends Pg Day Chicago has the best experience possible. Click below to find out how we are handling accessibility and accommodation:

https://2025.pgdaychicago.org/inclusion/

@PostgreSQL #postgres #conference

It’s just 3 days away! Join us on Tuesday April 8th at noon PST for "Where do Performance Cliffs Come From?" with Tomas Vondra! RSVP today!

https://www.meetup.com/postgresql-1/events/306484787/?eventOrigin=group_events_list

@PostgreSQL #Postgres #meetup

New episode of #TalkingPostgres #podcast

Bruce Momjian, #PostgreSQL core team member, joined me on Ep26 to talk about open source leadership—with rabbitholes on servant leadership, the art of public speaking, the power of gratitude, & bow ties

Boosts appreciated to help more people discover the podcast

https://talkingpostgres.com/episodes/open-source-leadership-with-bruce-momjian

https://youtu.be/gYG3FP-Csho?feature=shared

Are you ready for your close-up? Become a star today by joining PgUS!

https://postgresql.us/becomeamember/

Show HN: Hatchet v1 – a task orchestration platform built on Postgres

Link: https://github.com/hatchet-dev/hatchet
Discussion: https://news.ycombinator.com/item?id=43572733

Hatchet v1 – a task orchestration platform built on Postgres

https://github.com/hatchet-dev/hatchet

Our affiliated PUGs are looking for speakers! If you're local to one of the PUGs listed here: https://www.meetup.com/pro/postgresql/ and would like to present, contact us and we can put you in touch with the organizers!

https://buff.ly/4gfy2M3

Hey #Montreal, did you know Postgres Extensions Day is coming May 12?

Anyone working with PostgreSQL or who is interested in extension development can benefit from this event. Sign up for free, here: https://pgext.day

Questions? Get in touch with @yrashk

"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))

Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/

We're excited to announce Student PG DATA Day on 4/24/25, one day before PgDay Chicago. This event is intended for #students, but will also benefit junior #devs and anyone looking to learn about the open source DBMS, #PostgreSQL. Come by the event for training, mock interviews, & networking, and discover how to leverage #Postgres in new professional contexts.

For more info (including the schedule and registration!), check out our site: https://prairiepostgres.org

Please Welcome Prairie #Postgres! https://hdombrovskaya.wordpress.com/2025/04/02/please-welcome-prairie-postgres/

I been using #sqlfluff as my #LSP for #postgres.
It's safe to say, I should probably try this new one from Supabase.

Although, sqlfluff can run without a connection. And has sqlite as a dialect.

https://supabase.com/blog/postgres-language-server

Diversity and inclusion make for a brighter community and a brighter future for everyone. Take a look at how PgUS incorporates that into our organization:

https://postgresql.us/diversity/

A LIVE recording of Ep26 of the #TalkingPostgres #podcast will happen on Wed Apr 2 @ 10am PDT

If open source—or Postgres—is your jam , come join the parallel live text chat (& listen to the LIVE recording) on the Microsoft Open Source Discord

Guest: Bruce Momjian of EDB, member of #PostgreSQL core team & co-founder of the PostgreSQL Global Development Group
Topic: Open Source Leadership
Cal invite for parallel live text chat https://aka.ms/TalkingPostgres-Ep26-cal

#Postgres #databases #OpenSource #community #leadership #Microsoft

p.s. Boost to your friends please! And yes, you can also wait til the episode is published & download wherever you get your podcasts, to listen at your convenience!

I've published an annotated version of my slides from today's #DoKDay: https://karenjex.blogspot.com/2025/04/postgres-on-kubernetes-for-reluctant-dba.html

Thanks to the organisers, the other speakers, and of course the folks who came to join us!

Now to enjoy the rest of #KubeCon + #CloudNativeCon Europe 2025!