Planet PostgreSQL1h ago

Christophe Pettus: All Your GUCs in a Row: createrole_self_grant

https://postgr.es/p/9l4

#postgresql

All Your GUCs in a Row: createrole_self_grant

PostgreSQL 16 overhauled role management to tame the near-superuser power of CREATEROLE.

Hazelnoot4h ago
What's the next recovery step for #PostgreSQL when the WAL is still corrupted even after a successful pg_resetwal? Normally I'd just restore from backups at this point, but I'm helping someone else who doesn't have any to restore from.

My next recommendation is a hail-mary: delete the WAL files entirely, see if PG will recreate a stub, and dump whatever data's left after losing gigabytes of WAL logs. That's certainly not ideal, but I'm out of ideas and google isn't helping.

Edit: found a solution: just keep running pg_resetwal -f over and over until it finally works! Unfortunately, that only got me to the next issue: some actual data blocks are corrupted, including one holding part of the system catalog. So I can bring up the cluster and all data seems to be intact, but half of the tables are missing because the DDL itself is corrupted!
Planet PostgreSQL6h ago

Radim Marek: pg_stat_statements: everything it tells you

https://postgr.es/p/9l3

#postgresql

pg_stat_statements: everything it tells you

What pg_stat_statements records and what it quietly drops: the queryid jumble that splits one query into many rows, the frozen first-seen query text, and averages that hide your p99.

boringSQL | Supercharge your SQL & PostgreSQL powers
Jobs for Developers6h ago

Remote is hiring Senior Backend Engineer

🔧 #scala #angular #nextjs #react #vue #api #aws #cicd #docker #kubernetes #postgresql #seniorengineer
🌎 Remote; Europe
⏰ Full-time
🏢 Remote

Job details https://jobsfordevelopers.com/jobs/senior-backend-engineer-at-remote-com-apr-30-2026-69caca?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Senior Backend Engineer at Remote

Remote is hiring Senior Backend Engineer

Planet PostgreSQL7h ago

Robert Haas: Hacking Workshop for June/July 2026

https://postgr.es/p/9l2

#postgresql

Hacking Workshop for June/July 2026

I was hoping to usual resume the monthly cadence of hacking workshops in June, but it didn't quite happen, largely due to being a little exh...

pgEdge Postgres7h ago

An #AI agent can hallucinate a fact, build on it, and deliver a confident wrong answer nobody catches. No second pair of eyes.

Shaun Thomas's answer after two days at the AI Agent Conference in New York: #Postgres.

Not for RAG or pgvector - for the action ledger, RLS-backed policy store, & monitoring agents that run semantic searches over failure patterns. That's how you keep agent pipelines from going off the rails.

đź”— https://www.pgedge.com/blog/going-rogue-autonomous-ai-agents-and-postgres

#PostgreSQL #AIAgents #Data #OpenSource #Database

PgDay Boston9h ago

By sponsoring PgDay Boston, your company can be a part of building the local PostgreSQL community! Check out our sponsorship opportunities today!

https://2026.pgdayboston.org/sponsors/

#PostgreSQL #postgres #conference

Postgres Summit US9h ago

Thinking about attending PG Summit US but not sure how to fund it? As a community event, PG Summit US attendees are eligible to apply for Opportunity Grants that help fund travel expenses.

https://tinyurl.com/oppgrantapp

#PostgreSQL #postgres #conference

mastodon.raddemo.host10h ago

🚀 Deploy #Odoo on Rocky Linux #VPS

This guide walks through the steps to deploy Odoo on Rocky Linux VPS using PostgreSQL, #Python virtual environment, #Nginx reverse proxy, and systemd. This setup is production-ready and appropriate for business deployments.
What Is Odoo?
Odoo is an open-source business management platform that integrates many core business functions into one ...
Continued 👉 https://blog.radwebhosting.com/deploy-odoo-on-rocky-linux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #rockylinux #selfhosted #opensource #postgresql #letsencrypt #selfhosting

Planet PostgreSQL11h ago

Christophe Pettus: Managed Postgres, Examined: Azure Database for PostgreSQL Flexible Server

https://postgr.es/p/9l1

#postgresql

Managed Postgres, Examined: Azure Database for PostgreSQL Flexible Server

Azure's managed PostgreSQL differs from competitors by putting the standby in the commit path—every write waits for synchronous replication to a second server…