mastodon.ie is one of the many independent Mastodon servers you can use to participate in the fediverse.
Irish Mastodon - run from Ireland, we welcome all who respect the community rules and members.

Administered by:

Server stats:

1.6K
active users

#postgresql

24 posts23 participants2 posts today

Did you know? If you use materialized views in #postgresql, you ... probably can't restore backups created by pg_dump

I just hit this. Had materialized views which assumed that the search path was set to 'public' (which is the default, it's the schema all your tables are).

Upon restoring, the search path is cleared. Then materialized views are refreshed. This fails, because the search path isn't set to 'public'.

This is horrifying... #databases #postgres #sysadmin

Happening Wed Oct 8, a LIVE recording of the #TalkingPostgres podcast with amazing guest @tchorix of EDB, to talk about #PostgreSQL & The Fundamental Interconnectedness of All Things

Join Discord to be part of the parallel live text chat—or listen once Talking Postgres Ep32 is published on Friday (we always publish this monthly pod on a Friday...)
aka.ms/talkingpostgres-ep32-cal

Tell your database friends! Or your Hitchhikers Guide to the Galaxy friends... #OpenSource #podcast #Postgres #database

Did you know that you can run unit tests for your #Django app, in #GitHub Actions, using #PostgreSQL? I’m a little bit ashamed to admit that I had absolutely no idea until today. I really thought that I was forced to run my unit tests using Sqlite.

Quick article: loopwerk.io/articles/2025/gith

LoopwerkRun Django tests using PostgreSQL in GitHub ActionsDid you know that you can run unit tests for your Django app, in GitHub Actions, using PostgreSQL?

Missed seeing @c2main discuss PostgreSQL 18’s new cumulative stats system in his talk "Stats roll, baby, stats roll"?

Good news - you can catch it live at #PostgresIbiza on Oct. 16.

> [PACS] lets extension developers create custom statistics. This talk shows how PACS makes observability seamless, providing counters, gauges, buckets, and histograms integrated, similar to pg_stat_* views.

🍿 see you there?

On next Thursday, that's October 9th,I will givea talk at the 6. PostgreSQL User Group #NRW #MeetUp in Dortmund, Germany.
My talk is about time traveling data in #PostgreSQL.
The talk will be in German, but if attendattendees want to change it to English, I will happily agree 😉.
The talk was supposed to be given in Riga at the European PostgreSQL Conference, but due to personal reasons I will not be able to travel to Riga this year.
meetu.ps/e/PsNky/k17qn/I

Chat, I accidentally pg_dumpped (sql) a pg14 database (friggin immich stuck at 14) with pg_dump from pg16. That worked fine (why oh why did that not cause any errors!), but obviously now that I suddenly need said backup, a pg14 server is super unhappy with the backup and just screams syntax errors at me. How on earth can I restore this frankenbackup into anything that can then be downgraded back to pg14 so that Immich will be happy with it? I don’t think major version downgrades are even a thing?

My best idea is spinning up a throwaway pg16, restore there, dump it with pg14 (would that even work?) and then restore to pg14 proper. Just too tired by this point to attempt this safely without causing even more damage so better postpone it to tomorrow.

Asking lazyweb because search engines are toast and the internet is dying, or perhaps no one has ever failed in this stupid a way. Yes, I forgot that obviously my system postgres is new while Immich expects ancient. Fuck my life.

Now that #PostgreSQL18 has been released, it's a great time to learn about and experiment with #PostgreSQL Cumulative Statistics - an excellent feature that gives extension developers support for defining new statistics.

Learn more about stats (similar to what's in pg_stat* views & functions) and how to define your own views & functions in the future from @c2main:
mirrors.dotsrc.org/fosdem/2025

@fosdem #FOSDEM2025 #postgres #programming #coding #tech #developer #sql #data #learning #pg18 #statistics