Veganism Social

Douglas J HunleyMulti-Version Concurrency Control (MVCC) in <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>: Learning PostgreSQL with Grant <a href="https://www.red-gate.com/simple-talk/databases/postgresql/multi-version-concurrency-control-mvcc-in-postgresql-learning-postgresql-with-grant/" rel="nofollow noopener" translate="no" target="_blank">https://www.red-gate.com/simple-talk/databases/postgresql/multi-version-concurrency-control-mvcc-in-postgresql-learning-postgresql-with-grant/</a>

Shin.Ice :debian:Rant, work, EOL, PostgreSQL

Varun Dhaan<a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> 18 Beta 2 Released! 🐘 <a href="https://www.postgresql.org/about/news/postgresql-18-beta-2-released-3103/" rel="nofollow noopener" translate="no" target="_blank">https://www.postgresql.org/about/news/postgresql-18-beta-2-released-3103/</a>

BayAreaPostgresJoin us on Tuesday, August 12th at Noon PDT for "Gathering of the Herd - SF PUG Celebrates World Elephant Day!” with Federico Campoli and Stacey Haysler!<a href="https://www.meetup.com/postgresql-1/events/309042260/?eventOrigin=group_events_list" rel="nofollow noopener" translate="no" target="_blank">https://www.meetup.com/postgresql-1/events/309042260/?eventOrigin=group_events_list</a>@PostgreSQL <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/meetup" class="mention hashtag" rel="nofollow noopener" target="_blank">#meetup</a>

GripNews🌘 PostgreSQL 新系統檢視：檢查 DSM 登錄分配 ➤ 更方便的共享記憶體管理與監控 ✤ <a href="https://tselai.com/pg-dsm-registry-allocations" rel="nofollow noopener" translate="no" target="_blank">https://tselai.com/pg-dsm-registry-allocations</a> 這篇文章介紹了 PostgreSQL 中動態共享記憶體（DSM）登錄的新功能和系統檢視。新的 `GetNamedDSA()` 和 `GetNamedDSHash()` 函數簡化了 DSM 登錄中動態共享區域（DSA）和動態共享雜湊表（dshash）的分配。作者同時貢獻了新的 `pg_dsm_registry_allocations` 系統檢視，允許使用者檢查 DSM 登錄中的記憶體分配情況，包括擴充功能所使用的分配。 + 哇，這對開發 PostgreSQL 擴充功能的人來說真是個好消息！以前處理共享記憶體分配一直很麻煩，現在有了更簡潔的方式，還有可以監控的視圖，簡直太棒了！ + 雖然要等到 PostgreSQL 19 才能用，但這看起來真的很實用。如果我現在需要用到，可以直接套用 patch 嗎？作者願意提供協助真是太好了。 <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://mastodon.social/tags/%E6%95%B8%E6%93%9A%E5%BA%AB" class="mention hashtag" rel="nofollow noopener" target="_blank">#數據庫</a> <a href="https://mastodon.social/tags/%E9%96%8B%E7%99%BC" class="mention hashtag" rel="nofollow noopener" target="_blank">#開發</a>

Curated Hacker NewsSystem View for Inspecting DSM Registry Allocations in PostgreSQL<a href="https://tselai.com/pg-dsm-registry-allocations" rel="nofollow noopener" translate="no" target="_blank">https://tselai.com/pg-dsm-registry-allocations</a><a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a>

Douglas J Hunley<a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> Do not expose port 5432 to the public Internet <a href="https://thebuild.com/blog/2025/04/02/do-not-expose-port-5432-to-the-public-internet/" rel="nofollow noopener" translate="no" target="_blank">https://thebuild.com/blog/2025/04/02/do-not-expose-port-5432-to-the-public-internet/</a>

PgUSCollaboration is key when it comes to creating a diverse and inclusive community. The members of our Diversity Committee are constantly working towards the goal of a vibrant and collaborative community. <a href="https://postgresql.us/diversity/" rel="nofollow noopener" translate="no" target="_blank">https://postgresql.us/diversity/</a><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/diversity" class="mention hashtag" rel="nofollow noopener" target="_blank">#diversity</a> <a href="https://fosstodon.org/tags/inclusion" class="mention hashtag" rel="nofollow noopener" target="_blank">#inclusion</a>

n1k0<a href="https://mamot.fr/tags/JeRecrute" class="mention hashtag" rel="nofollow noopener" target="_blank">#JeRecrute</a> un•e ingénieur•e data/backend <a href="https://mamot.fr/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> / <a href="https://mamot.fr/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> pour Ecobalyse, la startup d’État qui calcule combien coûtent à la planète les mer^Wtrucs qu'on achètePS: ça va faire super malpoli/yolo mais je me casse en vacances ce soir et j'ai vraiment besoin d'un gros break donc je laisse mes adorables collègues dont <a href="https://mamot.fr/@vjousse" class="u-url mention" rel="nofollow noopener" target="_blank">@vjousse</a> vous filer toutes les infos complémentaires dont vous auriez besoin (désolé copain cœur sur tes mentions)<a href="https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/data-back-end-pour-ecobalyse-mte-ademe_paris" rel="nofollow noopener" translate="no" target="_blank">https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/data-back-end-pour-ecobalyse-mte-ademe_paris</a>

FrehiUpgraded a PostgreSQL server from Debian 12 to 13, and got hit by this bug:<a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789" rel="nofollow noopener" translate="no" target="_blank">https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789</a>resutling in the new postgresql version running with the wrong configuration after running pg_upgradecluster.<a href="https://fosstodon.org/tags/Debian" class="mention hashtag" rel="nofollow noopener" target="_blank">#Debian</a> <a href="https://fosstodon.org/tags/Trixie" class="mention hashtag" rel="nofollow noopener" target="_blank">#Trixie</a> <a href="https://fosstodon.org/tags/debian13" class="mention hashtag" rel="nofollow noopener" target="_blank">#debian13</a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/bug" class="mention hashtag" rel="nofollow noopener" target="_blank">#bug</a>

Federico Campoli :postgresql:PGDay Napoli 2025: La Prima Edizione è Qui! 🎉Il 25 settembre a Napoli ospiteremo il PGDay Napoli, la conferenza imperdibile per gli appassionati di PostgreSQL! Un'occasione unica per incontrare esperti internazionali, scoprire le ultime novità e fare networking.Il programma è online e le registrazioni sono aperte. Non perdere questa opportunità!<a href="https://2025.pgdaynapoli.org/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgdaynapoli.org/</a><a href="https://fosstodon.org/tags/PGDayNapoli" class="mention hashtag" rel="nofollow noopener" target="_blank">#PGDayNapoli</a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#Database</a> <a href="https://fosstodon.org/tags/TechEvent" class="mention hashtag" rel="nofollow noopener" target="_blank">#TechEvent</a> <a href="https://fosstodon.org/tags/Napoli" class="mention hashtag" rel="nofollow noopener" target="_blank">#Napoli</a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a> <a href="https://fosstodon.org/tags/PGDay" class="mention hashtag" rel="nofollow noopener" target="_blank">#PGDay</a>

PGDay NapoliCome see Priyanka Chatterjee talk about "All about Common Vulnerabilities and exposures in PostgreSQL"!<a href="https://mastodon.social/tags/awesome" class="mention hashtag" rel="nofollow noopener" target="_blank">#awesome</a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> <a href="https://mastodon.social/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a> <a href="https://mastodon.social/tags/pgday" class="mention hashtag" rel="nofollow noopener" target="_blank">#pgday</a> <a href="https://mastodon.social/tags/pgdaynapoli" class="mention hashtag" rel="nofollow noopener" target="_blank">#pgdaynapoli</a><a href="https://www.postgresql.eu/events/pgdaynapoli2025/sessions/session/6731-all-about-common-vulnerabilities-and-exposures-in-postgresql/" rel="nofollow noopener" translate="no" target="_blank">https://www.postgresql.eu/events/pgdaynapoli2025/sessions/session/6731-all-about-common-vulnerabilities-and-exposures-in-postgresql/</a>

Erik C. ThauvinHow we discovered, and recovered from, Postgres corruption on the matrix.org homeserver<a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mastodon.social/tags/matrix" class="mention hashtag" rel="nofollow noopener" target="_blank">#matrix</a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a><a href="https://matrix.org/blog/2025/07/postgres-corruption-postmortem/" rel="nofollow noopener" translate="no" target="_blank">https://matrix.org/blog/2025/07/postgres-corruption-postmortem/</a>

Juan Bitsits amazin how <a href="https://mastodon.mx/tags/pgbounce" class="mention hashtag" rel="nofollow noopener" target="_blank">#pgbounce</a> can reduce the direct connections to <a href="https://mastodon.mx/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> improving the responses and reducing error like: too many clients already

HackerNews VN botPhân tích sự cố sập database PostgreSQL của Matrix.org năm 2025, cách phát hiện lỗi và quy trình phục hồi. <a href="https://mastodon.maobui.com/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://mastodon.maobui.com/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#Database</a> <a href="https://mastodon.maobui.com/tags/Matrix" class="mention hashtag" rel="nofollow noopener" target="_blank">#Matrix</a> <a href="https://mastodon.maobui.com/tags/Debug" class="mention hashtag" rel="nofollow noopener" target="_blank">#Debug</a> <a href="https://mastodon.maobui.com/tags/Vietnamese" class="mention hashtag" rel="nofollow noopener" target="_blank">#Vietnamese</a> <a href="https://mastodon.maobui.com/tags/L%E1%BB%97i" class="mention hashtag" rel="nofollow noopener" target="_blank">#Lỗi</a> <a href="https://mastodon.maobui.com/tags/C%C6%A1" class="mention hashtag" rel="nofollow noopener" target="_blank">#Cơ</a> sở dữ liệu<a href="https://matrix.org/blog/2025/07/postgres-corruption-postmortem/" rel="nofollow noopener" translate="no" target="_blank">https://matrix.org/blog/2025/07/postgres-corruption-postmortem/</a>

Felix Denbratt<a href="https://mastodon.matrix.org/@matrix" class="u-url mention" rel="nofollow noopener" target="_blank">@matrix</a> very scary bug indeed. Well worth reading for anyone working with Ops. Thank you for sharing this Matrix! <a href="https://ioc.exchange/tags/devOps" class="mention hashtag" rel="nofollow noopener" target="_blank">#devOps</a> <a href="https://ioc.exchange/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> <a href="https://ioc.exchange/tags/postmortem" class="mention hashtag" rel="nofollow noopener" target="_blank">#postmortem</a>

PgUSAttending FOSSY in Portland, Ore? Got questions about PostgreSQL? Stop by and see us! <a href="https://2025.fossy.us/" rel="nofollow noopener" translate="no" target="_blank">https://2025.fossy.us/</a><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

Feed2Mastodon🚀 Mastodon v4.3.10 veröffentlicht.• 🔧 Abhängigkeiten aktualisiert. • 📚 Datenbank-Backups vor Updates empfohlen. • 🔧 `charlock_holmes` Gem-Build-Problem mit `gcc` möglich.<a href="https://github.com/mastodon/mastodon/releases/tag/v4.3.10" rel="nofollow noopener" translate="no" target="_blank">https://github.com/mastodon/mastodon/releases/tag/v4.3.10</a><a href="https://mastodon.hexix.de/tags/Mastodon" class="mention hashtag" rel="nofollow noopener" target="_blank">#Mastodon</a> <a href="https://mastodon.hexix.de/tags/Ruby" class="mention hashtag" rel="nofollow noopener" target="_blank">#Ruby</a> <a href="https://mastodon.hexix.de/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://mastodon.hexix.de/tags/Elasticsearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#Elasticsearch</a> <a href="https://mastodon.hexix.de/tags/Redis" class="mention hashtag" rel="nofollow noopener" target="_blank">#Redis</a> <a href="https://mastodon.hexix.de/tags/Nodejs" class="mention hashtag" rel="nofollow noopener" target="_blank">#Nodejs</a> <a href="https://mastodon.hexix.de/tags/LibreTranslate" class="mention hashtag" rel="nofollow noopener" target="_blank">#LibreTranslate</a> <a href="https://mastodon.hexix.de/tags/ImageMagick" class="mention hashtag" rel="nofollow noopener" target="_blank">#ImageMagick</a> <a href="https://mastodon.hexix.de/tags/libvips" class="mention hashtag" rel="nofollow noopener" target="_blank">#libvips</a>

PGXChristophe Pettus will be giving his new talk “Up Against the WAL: The Write-Ahead Log in PostgreSQL” at FOSSY 2025! We hope you’ll join him on Friday August 1st at 11:45 am PDT in Room 327!<a href="https://2025.fossy.us/schedule/presentation/355/" rel="nofollow noopener" translate="no" target="_blank">https://2025.fossy.us/schedule/presentation/355/</a>@cep@fostodon.org <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a> <a href="https://fosstodon.org/tags/Portland" class="mention hashtag" rel="nofollow noopener" target="_blank">#Portland</a>

Raphael (he/him)Not sure if I'm using the right search terms. Are there frameworks/languages for creating a <a href="https://mstdn.ca/tags/DataModel" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataModel</a>/business rules that would be cross-platform/cross-language, such that they could be enforced in <a href="https://mstdn.ca/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>, browser front-end, and in <a href="https://mstdn.ca/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a>? We're looking to apply this to a dataset that would be ingested automatically, while also having humans edit it in a browser, and would like the rules to be synchronized.

Recent searches

Search options

Administered by:

Server stats:

#postgresql