Boriss Mejias & Sarah Conway are part of the slate of speakers for #PosetteConf 2025. They will be telling a Postgres Story about "Cunning Schema Design with Creative Data Modeling" (Livestream 1 on Tue Jun 10th @ 9:00am PDT (UTC-7)). 
Learn more: https://posetteconf.com/2025/talks/postgres-storytelling-cunning-schema-design-with-creative-data-modeling/
Hallo zusammen,
ich versuche jetzt mal mein Glück und hoffe, auf diesem Weg eine Lösung für mein Problem mit der Datenbank meiner Mastodon-Instanz zu finden. Seit längerer Zeit kann ich kein vollständiges Datenbank-Backup mehr erstellen, weil das Backup immer wieder mit folgendem Fehler fehlschlägt:
pg_dump: error: Dumping the contents of table "accounts" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: missing chunk number 0 for toast value 661782 in pg_toast_16483
Ich habe bereits das Internet durchforstet, aber komme einfach auf keine vernünftige Lösung. Selbst die Methode auf dieser GitHub-Seite funktioniert bei mir nicht – oder ich stelle mich einfach zu dumm an:
https://github.com/xyhtac/postgres_table_recovery
Falls jemand eine Idee hat, wäre ich für jede Hilfe dankbar!
Klicke, um diesen Beitrag zu bewerten! [Gesamt: 0 Durchschnitt: 0]
If you use \H in psql it'll output the result as HTML
And \o [path starting from home directory] will save the result into a file instead of printing it out into the console
NULL in #Postgres just works in mysterious ways, HAVING NOT ('deprecated' = ANY (ARRAY_AGG(tag)) fails all the time when the tag array has a NULL from doing an empty LEFT JOIN.
I did a thing... and I should call it something like "My Nice #Postgres #Christmas" 
Inspired by their blue #elephant logo.
It's the best illustration of my current day, when I decided holiday seasons, between days free of work, are the best time to testing things, because most people took days off and don't disturb...
And now I am sitting with melted brain, tired by all this stuff 
The PGDay/MED call for Sponsors is now open!
There are two simple sponsorship levels, Partner and Supporter, giving you a chance to both showcase your services and products, and to support the community and the conference!
I want to move my #Postgres database from the VPS that Mastodon is on.
I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.
Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin
It's the Steller Plus plan at NameCheap
EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.
Tune in to Ep17 of #TalkingPostgres with @clairegiordano about 
Podcasting about Postgres with our former co-host Pino de Candia!
Great conversation about previous episodes, awesome #PostgreSQL guests, & shout-outs to other podcasts 
https://aka.ms/TalkingPostgres-Ep17-youtube
#podcast #opensource #community #database #postgres
Data Bene's Frédéric Delacourt will be providing a half-day of training on metrics collection at the #Postgres, #Linux, and #container level on Tues, Oct 22 at #PGConfEU in #Athens.
At the end of the talk, you should come away with a good understanding of what to monitor and why with appropriate resource allocations, alerting thresholds, and workflows configured.
Have you signed up for the conference yet? Slots for training are limited - register now!
Data Bene: Your go-to #PostgreSQL service provider and #FOSS advocate. We're globally distributed with decades of experience working with Postgres and open source technologies. We're committed to preventing vendor lock-in and promoting sustainable and secure business practices. Follow us for content around the Postgres community, open-source and cybersecurity news, and sustainable practices in tech.
Part of value prop of a #podcast is convenience (something I learned from @sogrady)
So yes, you can listen to all 16 past episodes of #TalkingPostgres (formerly called #PathToCitusCon) anywhere anytime anyplace!
Where? Walking the dog, doing the dishes, going for a run, sitting on a delayed plane 
on the tarmac somewhere...
& also subscribe for access to future episodes: https://talkingpostgres.com/subscribe
We're Hiring a Chief Technology Officer (CTO)!
Embark on an extraordinary journey with Software Heritage! Our work supports #OpenScience, #AI, and #Cybersecurity.
Key Responsibilities:
- Develop and implement the technical strategy
- Oversee technical development and ensure stability
- Drive innovation and manage technical debt
Our Tech Stack: #GNU/#Linux, #Python, #Rust, #Debian, #Puppet, #Kubernetes, #Postgres, #Ceph, #Cassandra, #Kafka.
For more info: https://www.softwareheritage.org/2024/06/28/chief-technology-officer-cto/
Selfhosted instance.
I am thinking of breaking #Postgres and #ElasticSearch to a separate server instead of increasing my current VPS resources.
I'll have two servers. My main, which will run Mastodon, and another that will have Postgres and ElasticSearch on it.
Will I benefit by doing this or should I just move ElasticSearch to its own server? What is the minimum CPU/ram I can get for the second server & what should I get?
Or, other thoughts welcomed.
#MastoAdmin
Just joined mastodon, giving up on X. My interests are #tech (#postgres #opensource) and #arts (#singing #drawing #watercolors)
Apparently, Postgres is getting multi-master support soon.
That is a big deal.
"#Postgres just passed the 25 year milestone as an open source project"
https://www.crunchydata.com/blog/when-did-postgres-become-cool
Sarah 
