#postgresql — Public Fediverse posts

Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

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

#postgresql

🚀 How to Deploy #Keycloak on #Ubuntu #VPS (5 Minute Quick-Start Guide)

Here’s a clear and detailed how-to guide for how to deploy Keycloak on Ubuntu VPS. This guide uses Keycloak in standalone mode with #PostgreSQL as the database and #NGINX as a reverse proxy with SSL.
What is Keycloak?
Keycloak is an open-source identity and access management (IAM) solution ...
Continued 👉 https://blog.radwebhosting.com/deploy-keycloak-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #letsencrypt #selfhosting #selfhosted #reverseproxy #opensource #openjdk #identitymanagement

Duck: DuckDB для Swift. Мощный SQL прямо в iOS и macOS приложениях

Уже много лет я занимаюсь Swift-разработкой, причем довольно значительная часть моих open-source проектов выросла из желания сделать повседневную работу с кодом максимально простой, красивой и приятной. За время работы на серверной стороне я привык к Postgres, к его мощному SQL и к тому, что с данными можно делать практически всё необходимое на уровне самой базы. Благодаря своим библиотекам я уже мог описывать таблицы обычными Swift-моделями, строить SQL с помощью type-safe key paths и пользоваться декларативным синтаксисом с result builders, который мне особенно нравится в современном Swift. У меня получился такой способ работы с БД, от которого мне совершенно не хотелось отказываться при переключении на iOS и macOS разработку. Заглядывайте в пост, чтобы узнать как я искал движок БД для моей новой разработки и что из этого получилось. Заглянуть

https://habr.com/ru/articles/1107762/

#sql #базы_данных #postgresql #ios #duckdb

🚀 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.social #letsencrypt #selfhosting #opensource #selfhosted #postgresql #rockylinux

2,991,149 orders & 0 failed writes. That's where our #KubeCon demo counter stopped when the show wrapped in Salt Lake City.

A #Postgres node in #Kubernetes went down & the CloudNativePG operator restarted its pod, then we cut the link between nodes & Spock, our open-source multi-master replication extension, synced both sides once it was back.

Want to break it on your own cluster? Ask for a 30-day evaluation 🧪 https://www.pgedge.com/download/enterprise-evaluation

#PostgreSQL #CloudNativePG #OpenSource #HighAvailability

Thursday 19/11! postgres.scot #meetup @ The University of Edinburgh with Alastair Turner (Percona)! "Gravity Wells and Guidebooks - AI Application Architecture by Analogy" The lessons we can, and the lessons we shouldn't, learn from previous efforts to drive value from data

https://cloomba.com/e/postgres-scot-nov-2026

#PostgreSQL #Postgres #AI

3 базы данных в Docker за один вечер: PostgreSQL 18 + ClickHouse 26.8 + Qdrant 1.19

TL;DR: Поднял локально полный аналитический стек - реляционная БД, OLAP-аналитика и векторный поиск для RAG. Всё в одном compose-файле, данные - на томах WSL, ноль облачных счетов. Под катом - установка за три шага и три ловушки, о которых молчат гайды.

https://habr.com/ru/articles/1107724/

#postgresql #docker #dockercompose #clickhouse #wsl #qdrant

That feeling of panic as one prepares to migrate an 8-terabyte #postgresql database to a new schema because, let's face it, you outgrew the original inefficient design about 7.5TB ago.

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

#PSA: Don't mix up PGDG and PGDG:

PGDG is the #PostgreSQL Global Development Group — good people and good software.

PGDG (.org) stands for "Pornography, Gambling, Drugs and Gaming" and seems to be a radical Christian sect or so… 🤪

And no, I don't know why the latter group use that #abbreviation because their full name actually seems "Stop Pornography, Gambling, Drugs and Gaming Addiction", but they don't call them "SPGDGA" and hence don't include the negation in their abbreviation. 🤷

#PGDG

Claude Code diagnosed 8 production Postgres incidents. In all 5 that hinged on concurrency, it shipped a fix and later walked it back. Each had an access gap, like no live pg_locks view or a deadlock DETAIL cut off by the app log. Its wrong guesses fit what it could see; a human who knew concurrency caught them.
https://arxiv.org/abs/2611.17304

Run the agent as shell claude to get a browser link that person can watch: https://shell.online

#AIAgents #PostgreSQL #DevOps

#PostgreSQL Just Patched 52 CVEs in a Single Minor Release https://vonng.com/en/pg/minor-earthquake/

PostgreSQL Patches 52 Flaws, Including 22-Year-Old Authenticated RCE Bug

Big news for database admins: PostgreSQL just patched a whopping 52 security flaws, including a 22-year-old vulnerability that could let hackers run code on your server - and we’re breaking down the details on the most critical one. The update fixes a type-confusion flaw, known as CVE-2026-6460, that allowed…

https://osintsights.com/postgresql-patches-52-flaws-including-22-year-old-authenticated-rce-bug?utm_source=mastodon&utm_medium=social

#AuthenticatedRce #Postgresql #Cve20266460 #SupplyChain #VulnerabilityManagement

PostgreSQL has released security updates addressing 52 flaws across multiple supported branches.

The release includes a fix for a long-standing type confusion vulnerability tracked as CVE-2026-6460, carrying a CVSS score of 8.8.

Affected versions include all releases prior to 18.7, 17.12, 16.16, 15.20, and 14.25, with version 14 marking the final release for that branch.

Full remediation requires updating the database s…

https://en.hacks.gr/i-postgresql-diorthonei-52-provlimata-asfaleias-perilamvanontas-keno-22-eton/

#PostgreSQL #Database #CVE20266460 #OpenSource

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

Minor upgrades are no longer a thing #postgresql

#PostgreSQL November 2026 minor releases: update the server and extensions together | Devrim's PostgreSQL Blog https://people.planetpostgresql.org/devrim/index.php?/archives/138-PostgreSQL-November-2026-minor-releases-update-the-server-and-extensions-together.html

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

Jeremy Schneider: Postgres 18.7 Debian and Redhat Packagers Protect You

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

#postgresql

Andrew Dunstan: Announcing Release 22 of the PostgreSQL Buildfarm client

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

#postgresql

New entry in #PostgreSQL Event Calendar:

🌐 Postgres Meetup for All

Date: 2026-12-16T05:00:00Z - 2026-12-16T06:00:00Z
Location: Online

ICS file: https://ics.postgresql.life/odvn3nosn2mvjoqc5dfgtmqgp4rvv892vc1tktdmk3vs2b2bgc503vksi1.ics
PostgreSQL Event Calendar: https://ics.postgresql.life/

#PostgreSQL Event Calendar, Reminder:

🌐 PUG Roundtable

Date: 2026-11-19T18:30:00Z - 2026-11-19T19:30:00Z
Location: online

ICS file: https://ics.postgresql.life/7phu5vqge59rg5uc2d6sn78qcm.ics

Dew Drop - November 13, 2026 (#4792)

https://alvinashcraft.com/2026/11/13/dew-drop-november-13-2026-4792/

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

Ruohang Feng: PostgreSQL Just Patched 52 CVEs in a Single Minor Release

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

#postgresql

Ruohang Feng: PostgreSQL Ate the Database World. Now the Giants Are Eating Postgres Companies.

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

#postgresql

#PostgreSQL Event Calendar, Reminder:

🌐 PostGIS Day 2026

Date: 2026-11-19
Location: Online

ICS file: https://ics.postgresql.life/rcqvojvr43nj8mhg14fdcikv9kkrutulvghjmk6ge77tk33cch0o0uivcm.ics

Релиз ProBackup 3.5.0: единый инструмент удалённого восстановления, синхронизация реплик и многопоточный retention

Компания Postgres Professional выпускает Postgres Pro Backup (ProBackup) 3.5.0 — очередное обновление инструмента резервного копирования и восстановления. В новой версии функциональность удалённого восстановления полностью объединена внутри основной утилиты, расширены возможности синхронизации реплик при расхождении линий времени, добавлена многопоточность при управлении политиками хранения, а также оптимизирована производительность работы с SFTP, S3 и сжатой файловой системой CFS.

https://habr.com/ru/companies/postgrespro/articles/1105344/

#резервное_копирование #postgresql #postgres #восстановление_данных #резервирование #probackup #postgres_pro_backup_enterprise #postgres_pro_backup

「PostgreSQL」でセキュリティアップデート、「PostgreSQL 14」は最後の更新に／52件の脆弱性と、ここ数カ月に報告された140件を超える不具合が修正
https://forest.watch.impress.co.jp/docs/news/2156215.html

#forest_watch_impress #PostgreSQL #PostgreSQL_19 #PostgreSQL_18 #PostgreSQL_14 #セキュリティ #脆弱性 #Windows #Mac #Linux #プログラミング

Save the date: FOSSASIA #PGDay, a full day of #PostgreSQL on 9 March 2027 in Bangkok, at FOSSASIA Summit. Submit your topics here https://eventyay.com/fossasia/pgday2027/cfp

PostgreSQL Sicherheitsupdate: 52 Schwachstellen in 18.7, 17.12, 16.16, 15.20 und 14.25 geschlossen

Die PostgreSQL Global Development Group hat Updates für alle unterstützten Versionen veröffentlicht. Sie schließen 52 Sicherheitslücken und beheben mehr als 140 Fehler. Bei 32 der Schwachstellen konnten authentifizierte Nutzer Code auf dem Datenbankserver ausführen. Für PostgreSQL 14 ist es die letzte Version.

https://www.all-about-security.de/postgresql-sicherheitsupdate-52-schwachstellen-in-18-7-17-12-16-16-15-20-und-14-25-geschlossen/

#schwachstellen #patch #postgresql

Parses pg_stat_statements output to surface your slowest queries. 252 lines, intermediate level, psycopg2-based. Run with your DSN and a ms threshold. #postgresql #python #database https://www.valtersit.com/python/postgresql-slow-query-log-parser/

PostgreSQL security update 18.7 fixes 52 CVEs, including CVE-2026-6460 and 31 other code execution flaws. PostgreSQL 14 reaches end of life.

#PostgreSQL #Postgres #DatabaseSecurity #CVE #PatchNow #RCE #CyberSecurity #InfoSec

https://securityonline.info/postgresql-security-update-52-cves/?utm_source=mastodon&utm_medium=jetpack_social

Greg Nancarrow: Build resilient AI workflows with DBOS and Fujitsu Enterprise Postgres

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

#postgresql

Lukas Fittl: Postgres 18.7 Security Release: The Impact of CVE-2026-6460 & other memory corruption issues

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

#postgresql

Every #PostgreSQL database collects history nobody reads but everybody pays for.

@vyruss built pgEdge ColdFront to move it into Apache Iceberg on cheaper storage, while apps query the same table & cold rows stay writable.

Got 5 minutes? That's his no-slides lightning talk at Community Over Code Glasgow: 🎬 https://www.youtube.com/watch?v=W5bWfGIAjgw

His write-up adds ColdFront running all 99 TPC-DS queries (#OpenSource, 1.0.0-beta3): 📖 https://vyruss.org/blog/community-over-code-glasgow-2026-coldfront-lightning-talk.html

#ApacheIceberg #Database #DataEngineering

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

Today #PostgreSQL 19 RC 2 has been released.
And the #Docker container is also already available.

Also the other PostgreSQL updated versions are there.

https://hub.docker.com/_/postgres/

Jeremy Schneider: Postgres 18.7 minor breaks ABI compatibility again

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

#postgresql

Turning a 22-year-old Postgres type-confusion primitive into RCE

https://mehmetince.net/part-3-6-how-i-ended-up-turning-a-22-year-old-postgresql-type-confusion-primitive-into-rce-cve-2026-6460/

#postgresql

Вышел Cozystack v1.7.0: поддержка ARM, Proxmox как альтернатива KubeVirt, автоматическая миграция с VMware и другое

Бывают релизы, а бывают релизы. Cozystack 1.7.0 из вторых. В нем не просто набор новых фичей, а такие фичи, которые снимают сразу несколько блокеров миграции на это решение. Этот релиз понравится тем, кто уже использует Proxmox, собирается переезжать с VMware, не хочет выставлять базы данных в мир без шифрования, а бэкапить планирует не только PostgreSQL. Но обо всем по порядку.

https://habr.com/ru/companies/aenix/articles/1106842/

#open_source #postgresql #redis #proxmox #devops #kafka #kubernetes #kubevirt #cozystack #aenix

🚀 How to Deploy #Coolify on #Ubuntu #VPS

This article provides a guide demonstrating how to deploy Coolify on Ubuntu VPS.
What is Coolify?
Coolify is an open-source, self-hosted Platform as a Service, or PaaS, that provides an interface for deploying and managing websites, applications, databases, and Docker-based services. It offers functionality similar to ...
Continued 👉 https://blog.radwebhosting.com/deploy-coolify-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mariadb #mongodb #paas #redis #postgresql #selfhosted #container #mysql #opensource #selfhosting

Jimmy Angelakos: Community Over Code Glasgow 2026 and a ColdFront lightning talk

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

#postgresql

@TheASF Community Over Code Glasgow 2026: my first one, and a lightning talk about ColdFront, transparent tiering from #PostgreSQL to Apache #Iceberg, in five minutes with no laptop and no slides (!)

https://vyruss.org/blog/community-over-code-glasgow-2026-coldfront-lightning-talk.html

#CommunityOverCode #Postgres #OpenSource

PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released

https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/

#postgresql

Mehmet Ince: Part 3/6 | How I Ended Up Turning a 22-Year-Old PostgreSQL Type-Confusion Primitive into RCE (CVE-2026-6460)

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

#postgresql

PostgreSQL Global Development Group released #PostgreSQL version 18.7. https://www.postgresql.org/download/

#PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released! https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/

Devrim GÜNDÜZ: PostgreSQL November 2026 minor releases: update the server and extensions together

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

#postgresql

pgBackRest and #PostgreSQL failover: why archive_mode matters https://pgstef.github.io/2026/09/23/pgbackrest_and_postgresql_failover_why_archive_mode_matters.html