Look who I've seen at #fosdem26 #fosdem ! #vlc #postgres #postgresql

Draw by @flyeen@bsky.app

Alt...

A picture with a big blue elephant costume and a person with a draw on the face and hand. The draw is a gnu head and hooves

Alt...

A selfie with JB Kempf, who has a traffic cone as a hat, and a person with a gnu draw on their face.

Note to self: do not kill a postgres process running ALTER TABLE in a throwaway database thinking it was the application while running pg_upgrade. It was pg_upgrade, not the app.

The "quick" rollback worked in terms of service (9 minutes of downtime) but it was an operational nightmare:

- outdated internal documentation
- very long Ansible loops
- unexpected errors when starting Debezium connectors that were stopped (why "stop/resume" and not "stop/start"?)
- pg_basebackup error: could not read COPY data: server closed the connection unexpectedly

And you, how's your week so far?

#postgresql #debezium #pg_upgrade #ansible

Changed to a ssd, but will see how it goes ...

If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a #PostgreSQL db or write the email watcher myself to put it into the consume folder.

It’s 2026 and we’re still happily using PostgreSQL 🐘

Open source, boring in the best possible way, stable, predictable, and without surprise license changes every six months ⚖️

Sometimes “just use Postgres” really is the best choice 🪄

https://www.tigerdata.com/blog/its-2026-just-use-postgres

#PostgreSQL #OpenSource #Databases

#PostgreSQL 18 supporte désormais nativement les UUID v7, vos Index vous diront merci !

L'un de nos #DBA consultants, Alain, nous explique pourquoi => https://dali.bo/202602_uuid

#SGBD #uuid
#opensource

Alt...

capture de l'article

I just did some cleanups of the sid-pgdg suite on apt.postgresql.org, removing some very old extension packages for postgresql-8.x. These were files from the very beginning of the archive in 2011. It's been a while... 🐘 #postgresql #debian

Alt...

A file listing with .deb files from 2011

Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite

https://sqldef.github.io/

#github #postgresql #sqlite

France Just Created Its Own Open Source Alternative to Microsoft Teams and Zoom

> Not only for them, but any other non-European videoconferencing software.
https://itsfoss.com/news/france-ditches-microsoft-teams-and-zoom/

https://hachyderm.io/@i47i/115972690862024866

https://lemmy.ml/post/42562289

#OpenSource #DigitalSovereignty #France #Lyon #FOSS #Linux #PublicSectorTech #Matrix #OnlyOffice #PostgreSQL

You know #Nginx, #PostgreSQL, #Iptables, and #Systemd. You don't need another #AWS #tutorial. You need a translation guide. 🤔

I made one: AWS concepts mapped to their traditional #Linux equivalents. Stop learning, start translating #SysAdmin #DevOps #Developers https://nskm.xyz/posts/aws-1/

Alt...

screen capture showing AWS terms and their Linux equivalent

We're hiring here at Data Bene! Our company specializes in PostgreSQL and the open-source ecosystem, and is looking for like-minded individuals to join us (from anywhere).

Currently available positions:

⭐ PostgreSQL Support Engineer
⭐ Technical Account Manager
⭐ Technical Lead Manager
⭐ C Developer

Learn more about our company and the positions, here: https://www.data-bene.io/en/jobs

#postgres #postgresql #opensource #francophone #logiciellibre #programmation #programming #developpeur #developpeuse

Alt...

A visualized version of the post contents

Today I finally upgraded my CloudNativePG DB from v17-bookworm to v18.1-trixie (minimal), and added Barman Cloud to backup to an external S3 bucket instead of relying on Kopia (filesystem).

A bit disappointing that client side encryption (GPG) still isn’t supported. It only supports SSE-S3 and SSE-KMS.

#homelab #postgresql #k8s #kubernetes @homelab

Have a good #fosdem #pgday today folks. Unfortunately, I couldn't make it this year #postgresql

Monitoring - PostgreSQL wiki
https://wiki.postgresql.org/wiki/Monitoring

#postgresql #monitoring

Le 3 février prochain, notre équipe tech et commerciale sera aux Cloud Native Days France.
Elle pourra parler, entre autres, de notre offre de support de #CloudNativePG.

Si vous êtes dans le coin… 😊

Toutes les infos utiles ici : https://www.cloudnativedays.fr/

#PostgreSQL #SGBD
#CNPG #kubernetes
#opensource

Alt...

visuel des Cloud Native Days France 2026

Le grand rassemblement annuel de la communauté PostgreSQL francophone, c'est le 3 et 4 juin prochain à Toulouse. Pour la seconde fois dans l'histoire des pgday FR, nous aurons le plaisir d'être accueillis par Météo France.

L'appel à conférencier est ouvert jusqu'au 8 mars, soumettez d'ores et déjà vos propositions sur https://pgday.fr/appel !

#PostgreSQL #pgday #cfp

I'm working on an Ansible collection of roles to manage PostgreSQL components for a year now. I'm starting the process to make it open source by following best practices like testing with molecule, run sanity checks, tweaking github actions to run tests against multiple matrices, releasing to galaxy. I hope it will be ready for FOSDEM 🤞🏻

#ansible #postgresql #fosdem

I guess we still have to run pg_dump/pg_restore to upgrade age databases on PostgreSQL in 2026 https://github.com/apache/age/issues/1422

#postgresql #age #upgrade

#dba #NotForAFriend

Neues auf der #bsdbox: Die Artikelstruktur wurde einer Erneuerung unterzogen. Dabei wurde die Seiten strukturell vereinheitlicht und eine Reihe von inhaltlichen Updates durchgeführt.

- Die #Nextcloud Reihe wurde komplett umgebaut
- Die #NGINX #PHP und #PostgreSQL Artikel wurden anders strukturiert
- Die Auslagerung in externe Datenverzeichnisse wurden entfernt
- Der "Konsole only" Bereich wurde ausgelagert
- Viele der Diagramme neu erstellt

https://bsdbox.de/blog/2026-01-18-updates

#FreeBSD # RunBSD

Alt...

Startseite von Nextcloud

News on the #bsdbox: The article structure has been revamped. The pages have been standardised in terms of structure and a number of content updates have also been made.

- The #Nextcloud series has been completely redesigned
- The #NGINX #PHP and #PostgreSQL articles have been restructured
- I have removed the outsourcing to external data directories everywhere
- The ‘console only’ section has been moved
- Many of the diagrams have been recreated

https://bsdbox.de/en/blog/2026-01-18-updates

#FreeBSD #RunBSD

Des nouveautés de #PostgreSQL18 à la sécurisation des données, en passant par les statistiques et #Kubernetes… 🐘

Les #conférences de la #pgsession18 auront lieu demain à Paris, mais comment y participer à distance ?

Voici le programme **à jour** et les liens utiles : https://dali.bo/202601_pgsession18_distance

#PostgreSQL #SGBD #DBA
#opensource #logicielsLibres

Alt...

Capture de l'article

"Debian 13.3 'Trixie' released: security updates & bug fixes for major components"

"Debianhas released version 13.3 of its stable 'Trixie' distribution, focusing on security updates and fixes for serious bugs."

https://alternativeto.net/news/2026/1/debian-13-3-trixie-released-security-updates-and-bug-fixes-for-major-components/

#PostgreSQL

Interesting article "I Replaced Redis with PostgreSQL (And It's Faster)" by Giuseppe Pollio on @thepracticaldev
https://dev.to/polliog/i-replaced-redis-with-postgresql-and-its-faster-4942
#PostgreSQL #Redis #Cache

Taming #PostgreSQL GUC “extra” Data https://clickhouse.com/blog/taming-postgres-guc-extra-data

💡 For the first time I just submitted a proposal for a new (small) feature in #django ; it's related to #fulltextsearch in #postgresql , especially for non-English websites/webapps . You can use Github reactions to let me know what you think about it 😉

https://github.com/django/new-features/issues/107

Instant database clones with #PostgreSQL 18 https://boringsql.com/posts/instant-database-clones/

PostgreSQL Hebdo #124 : https://sebastien.lardiere.net/blog/index.php/post/2026/01/07/PostgreSQL-Hebdo-124
#PostgreSQL

My first impressions of the #Zalando #postgresql operator are very good.

What you should know about constraints in #PostgreSQL | https://xata.io by Gulcin Yildirim Jelinek https://xata.io/blog/constraints-in-postgres

PostGIS Performance: Simplification | Crunchy Data Blog https://www.crunchydata.com/blog/postgis-performance-simplification #gis #postgresql

#PostgreSQL and #MongoDB: What Scaling Really Looks Like https://stormatics.tech/blogs/postgresql-mongodb-and-what-cannot-scale-really-means

Analyzing psqlrc Settings on GitHub: How #PostgreSQL Engineers Configure PostgreSQL https://dev.to/shinyakato_/analyzing-psqlrc-settings-on-github-how-postgresql-engineers-configure-postgresql-1b3f

Derniers jours pour soumettre votre proposition de sujet pour le #meetup #PostgreSQL se #Toulouse !

Que ce soit pour raconter pourquoi ou comment vous avez utilisé PostgreSQL, des anecdotes qui vous sont arrivées, en développement, déploiement, ou en opérations, votrr histoire nous interesse !

Vous hésitez? C'est votre première prise de parole ? On est là pour vous aider!

Proposez votre sujet ici : https://sessionize.com/tls-pug-session/

Il reste de la place!!

How to use #UUIDv7 in #Python, #Django and #PostgreSQL https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

RE: https://hachyderm.io/@clairegiordano/115696174046989768

Thank you for the little nudge out of my comfort zone, @clairegiordano - I'm looking forward to joining you on the #TalkingPostgres #podcast

#Postgres #PostgreSQL
#DBA #developer #OpenSource #community

Hey, I need help with #AWS #RDS.

I've this #Postgresql #RDS in private subnets.
I want to access it with the #psql cli (or any client really).

I see two ways.
One, which I find easy, with an #EC2 that acts as a #Bastion with #SSM so it remains private but requires a tunnel.
And one with a #RDSProxy exposed via a #NLB which is more involved but requires no tunnel.

Is there any other approach?
Something so obvious I missed it?

Thanks for your time and boosts in advance 🙇

EDIT: solution below

Moved all postings for the #PostgreSQL events calendar to this dedicated account:

@pgeventscalendar

The 1600 columns limit in PostgreSQL - how many columns fit into a table

https://andreas.scherbaum.la/post/2025-12-04_the-1600-columns-limit-in-postgresql-how-many-columns-fit-into-a-table/

#PostgreSQL

Postgres improves query planning for highly skewed data:

https://www.thatguyfromdelhi.com/2025/12/speed-up-join-planning-upto-16x-faster.html

#postgresql #performance #sql

Loading The Titanic Passenger Data Into #PostgreSQL With DBeaver Part 2 https://stokerpostgresql.blogspot.com/2025/10/loading-titanic-passenger-data-into_22.html

update: it looks like a #postgresql bug: if I name the argument in the definition but still use $1 in the body, it is replaced with `<func_name>.<param_name>` , documented in https://www.postgresql.org/docs/18/xfunc-sql.html#XFUNC-SQL-FUNCTION-ARGUMENTS

hmmm weird, I can't find any definition of [ pg_get_functiondef](https://www.postgresql.org/docs/18/functions-info.html#id-1.5.8.33.6.3.2.2.8.1.1.1) in #postgresql source code! anyone know why `$1` is replaced with <func_name>."" ?

We have PostgreSQL 14 on Debian 11 with TimescaleDB 2.16.1.
We want PostgreSQL 18 on Debian 13 with TimescaleDB 2.23.1.

But the support of TimescaleDB on PostgreSQL 14 ends at version 2.19.3.

On Debian 13 and PostgreSQL 18, the minimum version of TimescaleDB available is 2.23.0.

We have to upgrade with an intermediary step:

1. Upgrade TimescaleDB to 2.19.3 in-place
2. Upgrade to PostgreSQL 17 on Debian 12 (with TimescaleDB 2.19.3)
3. Upgrade TimescaleDB to 2.23.1
4. Upgrade to PostgreSQL 18 on Debian 13 (with TimescaleDB 2.23.1).

Add a multi-terabytes of data making dump/restore impossible.

At least the extension is available on Debian 13 which is not the case of age and Citus.

This is nice to have a 5 years support on PostgreSQL but beware if you use extensions. The time window could be less than that, complicating the upgrade process.

#postgresql #timescaledb #age #citus #upgrade #debian

> Unfortunately, after careful consideration, we've decided to move
forward with other candidates who more closely match our requirements for
this role

How I resent this idiotic piece of text, which is put into every damn rejection mail I receive since a year. More than 100 job applications sent out and no damn job afterwards. For fucks sake I was a senior #developer, a master of #ruby who did the last two years at the job #elixir and guess what did all the other #web backend related bullshit. Like administering #postgresql doing the schema, designing the whole architecture of a legacy backend system written in ruby, writing backends, frontends with #javascript and guess what nothing.

I maintained so called #microservices on #linux with fucking #docker which ran on #openshift or in the pedestrian terms "#kubernetes". Nothing!

I started into being a #software #developer through the damn #hacker scene and was a "founding member" (whatever that means) of a #hackerspace out of which I was kicked out and still suffering the emotional scars. But yeah, fuck that I see. And probably I'm at fault 100% because that's what this shitty #shame based society wants to tell everybody.

In my free-time I dabbled with #lisp #smalltalk and #cpp and #clang and #perl and I wrote #python a little for money too and for extending a little #django app at a hackerspace. Yeah, sure this is also worth nothing.

I tried to do #freelancing for 6 months, but guess what the current project market in #europe is shit and therefore nothing on the table for me either. While I find thousands of dimwits on reddits and everywhere, who are telling me that "I'm not an entrepreneur" or that "I deserve X", because they simply don't like what I write or my face.

Yeah sure, I'm 39 and I have no idea to go to, no damn #community and for fucks sake seem to be now going to join team long-term unemployed... because... yeah absolutely no damn fucking idea why I'm in this mess. What I'm supposed to do and obviously nobody fucking cares anyway.

I once dreamed of being "my own man", being that independent developer, coding happy #foss projects and contributing to #opensource and getting paid for that. But no. World says no to that. World says "go and die".

#job #hiring #getfedihired #gethired #rant

PostgreSQL 18 : des IO asynchrones performantes ! https://www.journalduhacker.net/s/tiydpx/postgresql_18_des_io_asynchrones https://blog.capdata.fr/index.php/postgresql-18-des-io-asynchrones-performantes/ #postgresql

#JeRecrute (enfin mon employeur) développeur·se expérimenté·e à l'aise avec #python #django #postgresql, la #data généralement et l'#infrastructure est un plus.

#Freelance ou #CDD de 18 mois.

En #télétravail et/ou bureau à #Paris et #Lyon !

https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/developpeur-se-django-back-end-senior

C'est là où je travaille, n'hésitez pas à poser des questions ! On vient de #BetaGouv, on est un GIP (groupement d'intérêt public) maintenant.

#ServicePublic #insertion

#TIL #postgres #PostgreSQL has E-strings, similar to Python's raw strings (r-strings). Thing is, I found out because a colleague used it to go around the fact that Postgres has a daemon level setting `standard_conforming_strings` that can change how it interpret backslashes in strings: either as a escape symbol or not.

That means that before sending any string to the server with backslashes, you have to either first query this parameter and adjust the strings you send; or use E-strings.

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

How to do UPDATE ... LIMIT in #PostgreSQL https://www.cybertec-postgresql.com/en/update-limit-in-postgresql/

#PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released! https://www.postgresql.org/about/news/postgresql-181-177-1611-1515-1420-and-1323-released-3171/

J'ai été ravie de présenter une keynote à PyCon FR 2025. Je partage ici les slides de ma conférence en forme de blog.

C'était mon premier #PyConFR et j'ai beaucoup apprécié cet événement acceuillant, bien organisé et avec des conférences hyper intéressantes et de trés bonne qualité.

J'espère revenir l'anné prochaine !

https://karenjex.blogspot.com/2025/11/le-reve-de-tout-enfant-devenir-dba.html

#Python #Postgres #PostgreSQL

Alt...

Dinosoar, "quand je serai frand je serai avocat", chaise "director"

WHO IS DATA BENE? We are a globally distributed services company headquartered in France, specializing in the #PostgreSQL ecosystem. 🐘

We are dedicated to contributions to the international Postgres community through conference participation, tool development, event organization, educational initiatives, & more. Our passion involves actively improving and creating #OpenSource tooling. 🤖

For #Postgres R&D projects or operational support, get in touch anytime: contact@data-bene.io

#tech #data

The CfP for the Databases devroom at FOSDEM is available https://fosdem-cloud-native-databases-devroom.github.io/

The devroom doesn't seem to be that much cloud native after all, but more of a bridge between MySQL and PostgreSQL communities.

This looks interesting from an open source DBA managing a fleet of half MySQL and half PostgreSQL instances.

#fosdem #postgresql #mysql #databases #community #devroom

Show me the users with MD5 passwords:

SELECT usename FROM pg_shadow WHERE passwd LIKE 'md5%'

However, if the user has NOLOGIN set, they won't show up in that table.

How do I find users with MD5 passwords with NOLOGIN set?

#PostgreSQL

Back from the engine room. Everything is up to date on our Mastodon instance:

Mastodon : 4.5.0-rc.3
Ruby: 3.4.7
PostgreSQL : 18.0
Redis: 8.0.2
Elasticsearch: 7.17.29

Also all operating system updates deployed and re-organized the PostgreSQL database with a pg_repack.

Few technical stats:
Database size: 22,1 GB
Media size (S3 Storage): 142 GB
Elasticsearch size: ~ 10 GB

All looking pretty healthy, stable, realiable. Running like a well oiled machine 🙂

#mastodon #maintanance #mastoadmin #postgresql
@tux

Retour sur la PostgreSQL Conference Europe 2025 : https://www.loxodata.com/post/pgconf-eu-2025-report/
#PostgreSQL

PostgreSQL Hebdo #123 : https://sebastien.lardiere.net/blog/index.php/post/2025/11/04/PostgreSQL-Hebdo-123
#PostgreSQL

Cet articlesuggère que PostgreSQL peut à peu près tout faire et représente donc une solution idéale pour la majorité des boîtes dont les besoins en *scalabilité* (évolution de la charge) ne seront jamais suffisants pour justifier une infra plus complexe.

C'est l'idée de *MVI : minimum viable infrastructure*.

J'aime bien le côté pragmatique, même si ça implique, de fait, une très grande maîtrise de PostgreSQL.

🔗 https://topicpartition.io/blog/postgres-pubsub-queue-benchmarks#user-content-fnref-13

#infrastructure #architecture #postgresql

Not that I want to use it, but I'm curious as to why the #PostgreSQL BSD Authentication method is available only on OpenBSD.

20.14. BSD Authentication

This authentication method operates similarly to password except that it uses BSD Authentication to verify the password. BSD Authentication is used only to validate user name/password pairs. Therefore the user's role must already exist in the database before BSD Authentication can be used for authentication. The BSD Authentication framework is currently only available on OpenBSD.

re https://www.postgresql.org/docs/18/auth-bsd.html

I've just added a new item to list of future tasks:

0000335: MD5 password support is deprecated and will be removed in a future release of PostgreSQL

From https://www.postgresql.org/docs/current/auth-password.html

To upgrade an existing installation from md5 to scram-sha-256, after having ensured that all client libraries in use are new enough to support SCRAM, set password_encryption = 'scram-sha-256' in postgresql.conf, make all users set new passwords, and change the authentication method specifications in pg_hba.conf to scram-sha-256.

#PostgreSQL

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

psql -h Toulouse -d meteofrance est la nouvelle session #Meetup de #Toulouse #PostgreSQL User Group à Toulouse France : 2026-01-13T18:00 - 21:30 chez Météo-France

Meetup : https://www.meetup.com/postgres-toulouse/events/311744824/
CFP se termine le 2025-12-13 :! https://sessionize.com/tls-pug-session/

---

psql -h Toulouse -d meteofrance is the new PostgreSQL Toulouse Meetup gathering in Toulouse France : 2026-01-13T18:00 - 21:30
Meetup : https://www.meetup.com/postgres-toulouse/events/311744824/
CFP ends 2025-12-13 :! https://sessionize.com/tls-pug-session/

Alt...

L'image comprend une photo de la garonne et le dome de lagrave, le logo du groupe et l'information : Meetup PostgreSQL User Group Toulouse France le 13 janvier 2026 à 18h00 chez MétéoFrance. Le nom de la session est psql -h Toulouse -d meteofrance Une illustration d'un éléphant tenant un panneau "Save the date"

Recently set up email with #opensmtpd #dovecot , and #rspamd on #FreeBSD jails thanks to @mwl@mwl.io book #RYOMS https://mwl.io/nonfiction/tools#ryoms and. @stefano posting a step by step guide https://it-notes.dragas.net/2024/03/08/make-your-own-email-server-freebsd-opensmptd-rspamd-dovecot-part1/
and @BastilleBSD tooling to make jails easier to configure and test.

Previously, I had only used a development setup that included #postfix for internal testing.

I even got my first DMARC report...because the previous mx is still forwarding to my account on a large provider, and i didn't include it in the spf record.

It is currently IMAP only access because I don't need webmail, but I'll probably add that with a #postgresql or #LDAP backend since the separate passwd file would require manual editing, which isn't reasonable if other people need to update passwords.

I am grateful for all the people who made the tools and documentation so that it is possible to host my own email in 2025.

*edited to hopefully fix account links from mobile posting.

Meetup PostgreSQL à Toulouse, le 13 janvier 2026, vous pouvez proposer vos sujets : https://sessionize.com/tls-pug-session/
#PostgreSQL #Toulouse

@nixCraft I wouldn't mind #PostgreSQL actually improving docker image major-versions upgrades... =,=

What are the things to keep in mind for using #JSON types in #postgresql ? Never used it before.

Critical PostgreSQL bug tied to zero-day attack on US Treasury

A high-severity SQL injection bug in the #PostgreSQL interactive tool was exploited alongside the zero-day used to break into the US Treasury in December, researchers say.

Rapid7's principal security researcher, Stephen Fewer, disclosed CVE-2025-1094 (8.1) on Thursday, saying it was a key part of the exploit chain that also included the BeyondTrust zero-day (CVE-2024-12356).

https://www.theregister.com/2025/02/14/postgresql_bug_treasury/ #infosec

Il a suffi qu’une personne parle de https://monrer.fr sur un certain réseau social à une lettre pour que le site se prenne en une journée de week-end l’équivalent de trois jours de trafic normal en semaine.

En tout cas, ça a l’air d’avoir bien tenu, et c’est à la fois grâce à mes efforts d’optimisation et à la puissance de #Perl et de #PostgreSQL sur #FreeBSD !

🔁 Tired of manual schema updates in distributed Postgres?
Watch Hari Kiran show how pgEdge brings automatic DDL replication—syncing schema changes across nodes effortlessly and reducing errors at #FOSSASIASummit2025

🎥 Click here to watch: https://youtu.be/4d_h-Wkjtic
#PostgreSQL #pgEdge #OpenSource #DevOps #Database

Karen JEX (Crunchy Data) nous présente "Postgres sur Kubernetes pour le DBA réticent". A retrouver sur https://www.youtube.com/watch?v=MSQNP9ZTuxU .

#postgresql #pgday

#postgresql Mini Summit 3 Transcript: Apt Extension Packaging https://justatheory.com/2025/04/mini-summit-three/