#dba — Public Fediverse posts

If you've missed Dr. Ibrar Ahmed's "Eight Steps to Bullet-Proof #Database Disaster Recovery" conference talk, he's giving it live (online, free!) this Nov 19th at 8AM PST.

Learn how to handle everything from start to finish:
- early-detection based on log analysis, inconsistent WAL records, etc.
- how to handle disaster recovery
- practical measures to reduce future risk
& much more.

Q&A after - register now to attend or save for on-demand.

https://us02web.zoom.us/webinar/register/WN_3tmevZXDTKCGsSFLwPcm0A

#dba #postgresql #data

CW: biztonság

Új PostgreSQL‑kiadások: 52 javított CVE (több kritikus, CVSS ~8.8), 140+ hibajavítás. Okai: AI/LLM‑ek miatt megnövekedett hibajelentési terhelés; a PostgreSQL 15 elérte az életciklus végét. Frissítsen éles rendszereknél prioritással.

https://linuxmint.hu/hir/2026/11/uj-postgresql-kiadasok-52-biztonsagi-res-es-tobb-mint-140-hibajavitas-miatt

#PostgreSQL #security #DBA #OpenSource

Cool, I didn't expect an ABI change in the last MINOR release of the Debian packaging of the PostgreSQL packages.

We don't pin most of the extensions, like ip4r, partman, vector, etc, so a reinstall of a server that is not running on the very last minor release breaks, on a Friday.

At the same time, we found out that our old version of TimescaleDB broke compatibility with the last PostgreSQL MINOR releases.

OK, it's Friday, 6:00 pm. Time to go off.

#postgresql #dba #friday #upgrades

RELEASE : la communauté #PostgreSQL a annoncé hier la mise à jour de toutes les versions supportées, ainsi que la release candidate de PostgreSQL 19. Bravo à elle pour sa constance. 💐

Voici la traduction de nos collègues #DBA => https://dali.bo/202611_release

#SGBD #opensource
#update #upgrade

After spotting corruption in a #PostgreSQL cluster, stop the service before anything else writes to the damaged files.

Dr. Ibrar Ahmed, who's worked on the Postgres core engine since 2006, covers the full recovery order in a free pgEdge webinar on Nov 19, 8 AM PT (4 PM GMT): verified backups, point-in-time recovery, salvaging healthy tables, & why pg_resetwal is a last resort.

Live Q&A after, & registering gets you the recording: 🎙️ https://us02web.zoom.us/webinar/register/WN_3tmevZXDTKCGsSFLwPcm0A

#Database #DBA #DevOps #SysAdmin