#postgresql — Public Fediverse posts

Our online affiliated PUGs are looking for speakers! If you aren’t local to an in-person PUG, we can put you in touch with the organizers of Postgres for All and SF PUG. Contact us today and grow your reputation as a speaker!

https://bit.ly/PUGspeaker

#PostgreSQL #postgres

Our online affiliated PUGs are looking for speakers! If you aren’t local to an in-person PUG, we can put you in touch with the organizers of Postgres for All and SF PUG. Contact us today and grow your reputation as a speaker!

https://bit.ly/PUGspeaker

#PostgreSQL #postgres

Full Guide to #PostgreSQL #Database Management in #cPanel Here's a comprehensive guide on PostgreSQL database management in cPanel accounts, designed for developers, sysadmins, or site owners using cPanel-managed hosting.
What is PostgreSQL?
PostgreSQL is an open-source, ...
Continued 👉

Full Guide to PostgreSQL Datab...

#postgresql is having good time with #rust

I wonder if anyone using pgrust in prod and how it's compared to others?

[#Postgres FM] #pgrust
https://podcastaddict.com/postgres-fm/episode/230421188 via @PodcastAddict

#postgresql is having good time with #rust

I wonder if anyone using pgrust in prod and how it's compared to others?

[#Postgres FM] #pgrust
https://podcastaddict.com/postgres-fm/episode/230421188 via @PodcastAddict

On Thursday, I have upgraded the most important (MySQL) database at work and it went not very well. There were a few unexpected misconfigurations and unhandled errors that lead to more or less 10 minutes of downtime instead of 1 or 2 and a Debezium connector snapshot, which is VERY costly for Kafka consumers.

Fortunately, we have learned from our mistakes and I have patched our Ansible playbooks to prevent all those issues from happening again.

This morning, I have upgraded one of the most important Mastodon (PostgreSQL) databases without any issue.

#mysql #postgresql #dba #ansible #automation #databases #mastodon

On Thursday, I have upgraded the most important (MySQL) database at work and it went not very well. There were a few unexpected misconfigurations and unhandled errors that lead to more or less 10 minutes of downtime instead of 1 or 2 and a Debezium connector snapshot, which is VERY costly for Kafka consumers.

Fortunately, we have learned from our mistakes and I have patched our Ansible playbooks to prevent all those issues from happening again.

This morning, I have upgraded one of the most important Mastodon (PostgreSQL) databases without any issue.

#mysql #postgresql #dba #ansible #automation #databases #mastodon

Christophe Pettus: All Your GUCs in a Row: jit and jit_provider

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

#postgresql

Most tiering solutions force a choice: keep data in #PostgreSQL & pay SSD prices, or move it somewhere cheaper & lose writability. ColdFront doesn't.

@vyruss who led the development on it walks through the engineering on Aug 19 @ 8 AM PT, including how TLA+ formal verification shaped the write protocol. Paul Rothrock follows with a live demo, including GDPR deletion on archived data.

Register: 👉 https://us02web.zoom.us/webinar/register/WN_3oRFbue0QL2UI7j9DmCbFA#/registration

#OpenSource #ApacheIceberg #DatabaseEngineering #DBA #PostgreSQL #Postgres

Most tiering solutions force a choice: keep data in #PostgreSQL & pay SSD prices, or move it somewhere cheaper & lose writability. ColdFront doesn't.

@vyruss who led the development on it walks through the engineering on Aug 19 @ 8 AM PT, including how TLA+ formal verification shaped the write protocol. Paul Rothrock follows with a live demo, including GDPR deletion on archived data.

Register: 👉 https://us02web.zoom.us/webinar/register/WN_3oRFbue0QL2UI7j9DmCbFA#/registration

#OpenSource #ApacheIceberg #DatabaseEngineering #DBA #PostgreSQL #Postgres

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

"Changing pg_hba.conf to trust is how databases get dumped. That one line opens your Postgres to the entire internet. Here's what attackers do next and how to lock it down. #PostgreSQL #Security #Database"

https://www.valtersit.com/guides/databases/the-pg_hba_conf-trust-trap-how-to-give-your-postgresql-database-away-for-free/

HA: Отказоустойчивость PostgreSQL. Transaction Guard

При создании отказоустойчивых систем, стремятся гарантировать отсутствие потерь транзакций при восстановлении из бэкапов или при переключении на реплику (резервный кластер баз данных). В статье рассматривается, в коде приложения можно выяснить, была ли потеряна транзакция при переключении на реплику (promote).

https://habr.com/ru/companies/tantor/articles/1070686/

#patroni #postgres #postgresql #transaction #highavailability

Learn all about “From Oracle to Postgres for 40 Million Users: What a National G2C Migration Actually Looks Like” with Hari Kiran at Postgres Summit US 2026!

https://postgresql.us/events/postgressummitus2026/schedule/session/2344-from-oracle-to-postgres-for-40-million-users-what-a-national-g2c-migration-actually-looks-like/

#PostgreSQL #postgres #conference

Learn all about “From Oracle to Postgres for 40 Million Users: What a National G2C Migration Actually Looks Like” with Hari Kiran at Postgres Summit US 2026!

https://postgresql.us/events/postgressummitus2026/schedule/session/2344-from-oracle-to-postgres-for-40-million-users-what-a-national-g2c-migration-actually-looks-like/

#PostgreSQL #postgres #conference

LinkedIn Live: Fixing Bad SQL in #PostgreSQL with Jimmy Angelakos https://vyruss.org/blog/linkedin-live-fixing-bad-sql-in-postgresql.html

LinkedIn Live: Fixing Bad SQL in #PostgreSQL with Jimmy Angelakos https://vyruss.org/blog/linkedin-live-fixing-bad-sql-in-postgresql.html

Joshua Drake: Parquet and Iceberg: An Overview

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

#postgresql

Joshua Drake: Parquet and Iceberg: An Overview

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

#postgresql

Planning on attending PG Summit US? We have a discounted rate with Wyndham Garden Chinatown! Check it out and book soon, the deadline is August 28th! That’s 2 weeks from today!

https://2026.postgressummit.us/attend/hotels/

#PostgreSQL #postgres #conference

Planning on attending PG Summit US? We have a discounted rate with Wyndham Garden Chinatown! Check it out and book soon, the deadline is August 28th! That’s 2 weeks from today!

https://2026.postgressummit.us/attend/hotels/

#PostgreSQL #postgres #conference

How SQL/PGQ Rewrites to Joins on #PostgreSQL 19 https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/

How SQL/PGQ Rewrites to Joins on #PostgreSQL 19 https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/

Your weekend watch is “Vibe Coding with Postgres” with Matt Cornillon:

https://www.youtube.com/watch?v=o0E9soJg9JE

#PostgreSQL #postgres

Your weekend watch is “Vibe Coding with Postgres” with Matt Cornillon:

https://www.youtube.com/watch?v=o0E9soJg9JE

#PostgreSQL #postgres

Does anyone run Postgres without PgBouncer? — brandur.org
https://brandur.org/fragments/postgres-without-pgbouncer

#postgresql

🚀 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 ...
Continued 👉 #selfhosting #paas #opensource #postgresql #mariadb #selfhosted #mongodb #mysql #container #redis

🚀 How to Deploy Coolify on Ubu...

🚀 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 ...
Continued 👉 #selfhosting #paas #opensource #postgresql #mariadb #selfhosted #mongodb #mysql #container #redis

🚀 How to Deploy Coolify on Ubu...

「PostgreSQL」にセキュリティアップデート、任意コード実行を含む28件の脆弱性に対処／「PostgreSQL 14」は2026年11月12日でサポートが終了、早めの移行計画を
https://forest.watch.impress.co.jp/docs/news/2132677.html

#forest_watch_impress #PostgreSQL #PostgreSQL_19 #プログラミング #Windows #Mac #Linux

「PostgreSQL」にセキュリティアップデート、任意コード実行を含む28件の脆弱性に対処／「PostgreSQL 14」は2026年11月12日でサポートが終了、早めの移行計画を
https://forest.watch.impress.co.jp/docs/news/2132677.html

#forest_watch_impress #PostgreSQL #PostgreSQL_19 #プログラミング #Windows #Mac #Linux

Christophe Pettus: All Your GUCs in a Row: io_method and io_workers

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: io_method and io_workers

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

#postgresql

Welcome to pg_walviz: #PostgreSQL WAL segment visualizer: https://bdrouvot.github.io/2026/08/13/welcome-to-pg-walviz-postgresql-wal-segment-visualizer/

Welcome to pg_walviz: #PostgreSQL WAL segment visualizer: https://bdrouvot.github.io/2026/08/13/welcome-to-pg-walviz-postgresql-wal-segment-visualizer/

Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

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

#postgresql

Bertrand Drouvot: Welcome to pg_walviz: PostgreSQL WAL segment visualizer

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

#postgresql

Bertrand Drouvot: Welcome to pg_walviz: PostgreSQL WAL segment visualizer

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

#postgresql

Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

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

#postgresql

Attending KCDC? Our Community Booth will be there and is looking for volunteers. It’s a great way to meet new people and become more involved with the community!

https://bit.ly/pgusvolunteer

#PostgreSQL #postgres #conference

Attending KCDC? Our Community Booth will be there and is looking for volunteers. It’s a great way to meet new people and become more involved with the community!

https://bit.ly/pgusvolunteer

#PostgreSQL #postgres #conference

PGX is proud of our commitment to the PostgreSQL Community. That's why we encourage each of our employees to volunteer for PgUS and its affiliated conferences and User Groups.

https://pgexperts.com/corporate/community

#PostgreSQL #postgres

PGX is proud of our commitment to the PostgreSQL Community. That's why we encourage each of our employees to volunteer for PgUS and its affiliated conferences and User Groups.

https://pgexperts.com/corporate/community

#PostgreSQL #postgres

Join us for “Always Be Repacking: Architecting a Continuous Repacking Orchestrator for High-Throughput PostgreSQL” with Ankit Mittal at Postgres Summit US 2026!

https://postgresql.us/events/postgressummitus2026/schedule/session/2427-always-be-repacking-architecting-a-continuous-repacking-orchestrator-for-high-throughput-postgresql/

#PostgreSQL #postgres #conference

Join us for “Always Be Repacking: Architecting a Continuous Repacking Orchestrator for High-Throughput PostgreSQL” with Ankit Mittal at Postgres Summit US 2026!

https://postgresql.us/events/postgressummitus2026/schedule/session/2427-always-be-repacking-architecting-a-continuous-repacking-orchestrator-for-high-throughput-postgresql/

#PostgreSQL #postgres #conference

KnowBe4 is hiring Senior Software Engineer

🔧 #ruby #typescript #react #rubyonrails #serverless #vue #graphql #aws #cicd #css #mysql #postgresql #redis #awss3 #tailwind #terraform #seniorengineer
🌎 Sao Paulo, Brazil
⏰ Full-time
🏢 KnowBe4

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-at-knowbe-4-com-jul-24-2026-33b0a8?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

KnowBe4 is hiring Senior Software Engineer

🔧 #ruby #typescript #react #rubyonrails #serverless #vue #graphql #aws #cicd #css #mysql #postgresql #redis #awss3 #tailwind #terraform #seniorengineer
🌎 Sao Paulo, Brazil
⏰ Full-time
🏢 KnowBe4

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-at-knowbe-4-com-jul-24-2026-33b0a8?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

redb 3.6.0: багрепорт, который оказался в шести провайдерах сразу — плюс AS2/EDI и общий порт

Отчёт пользователя вскрыл утечку между диалогами в query-провайдере ядра — 6 из 6. Что ещё в 3.6.0: AS2/EDI, общий Kestrel, Camel-паритет. Год стек рос на наших собственных задачах: мы писали то, что нужно было нам, и проверяли на своей проде. С весны им начали пользоваться посторонние люди — и характер входящих сообщений изменился. Вместо «а поддерживаете ли вы X» приходят разборы: воспроизведение, номера строк в наших исходниках, обходные пути, которые человек уже написал у себя, пока ждал ответа. Это самое ценное, что может случиться с проектом. Спасибо всем, кто не поленился написать вместо того, чтобы молча уйти на другую библиотеку. Один такой отчёт лежит в основе половины этого релиза — и вскрытый им дефект оказался вовсе не там, где его нашли. Итак, redb 3.6.0 : ядро, интеграционный движок redb.Route , рантайм redb.Tsak и OIDC-сервер redb.Identity — все на одном номере, 63 пакета.

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

#dotnet #integration #esb #postgresql #llm #edi

Still on the fence about attending Postgres Summit US? Not sure how to approach your manager about conference expenses? We make it easy! Check out our “Make the Case” page. It contains all the information you need!

https://2026.postgressummit.us/attend/justify/

#PostgreSQL #postgres #conference

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

#PostgreSQL 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3 Released! https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/