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/

Instant database clones with PostgreSQL 18

Link: https://boringsql.com/posts/instant-database-clones/
Discussion: https://news.ycombinator.com/item?id=46363360

#postgresql

Migrated the database of my Mastodon instance burnignboard.net from Linux to PostgreSQL+Valkey on FreeBSD (+zfs)

All looking perfectly fine :) Although there's quite a lot of activity, the AMD EPYC Rome system is pretty much idling with the load being at 0.28 🙂

#mastodon #freebsd #postgresql #valkey

Sorry für die 30-minütige Ausfallzeit unserer Mastodon-Instanz burningboard.net.

Zumindest laufen wir jetzt mit VIEL MEHR RESSOURCEN !! :-) Die Datenbanken (PostgreSQL und Valkey) laufen jetzt auf einem separaten Host innerhalb desselben LAN (und auf FreeBSD+ZFS).

#mastodon #mastoadmin #freebsd #postgresql @tux

Sorry for the 30 min downtime at our Mastodon instance burningboard.net.

At least we're now running on A LOT MORE RESOURCES !! :-) The Databases (PostgreSQL and Valkey) are now running on a seperate host within the same LAN (and on FreeBSD+ZFS)

#mastodon #mastoadmin #freebsd #postgresql @tux

Released PyGreSQL 6.2.0 #PostgreSQL adapter for #Python https://pygresql.github.io/

Your weekend watch is “Full Text Search in Postgres with Tantivy” with Philippe Noël:

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

#PostgreSQL #postgres

RE: https://en.osm.town/@amapanda/115740634441054421

The magic that makes this work is `count(*) over (partition by name)`. It's a #PostgreSQL window function, that says, for each place object, “count how many there are, but only those with the same name”.

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

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

1. "Our problem has unique requirements"
2. Builds custom solution on "specialized" platforms
3. Realizes Postgres could have handled it fine

Everyone's use case is exceptional... until you prove it isn't.

#PostgreSQL #Postgres #OpenSource #Database #SystemsDesign #SystemsEngineering

Alt...

A weathered reference book on a desk with computer and coffee mug. The book title is "Everyone's use case is exceptional... until you prove it isn't". Subtitle: "A database architect's field guide."

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

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"

Any good #PostgreSQL data testing tool?

I have some code processing which fills a PG db with stuff. Is there any way I can write unit tests for that? Where I can define a known PG database output, and it'll just login and tell me if it's the same data?

I'm sure I can do this easily myself with a script, pg_dump & diff(1). But tis always good to check first,

PGLoader is an absolute unsung hero: it turns rubbish into usable databases.

This is the stuff that should be "trending" on github, but it isn't, because it works too well, and everything runs smoothly, so there's not much buzz/discussion around it.

https://pgloader.readthedocs.io/en/latest/ref/mysql.html

#Postgresql

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

https://topicpartition.io/blog/postgres-pubsub-queue-benchmarks #postgresql

Alt...

At small scale, these systems hurt you more than they benefit you. Distributed systems - both in terms of node count and system cardinality - should be respected, feared, avoided and em- ployed only as a weapon of last resort against par- ticularly gnarly problems. Everything with a dis- tributed system becomes more challenging and time-consuming. The problem is the organizational overhead. The organizational overhead of adopting a new system, learning its nuances, configs, establishing monitoring, establishing processes around deploy- ments and upgrades, attaining operational exper- tise on how to manage it, creating runbooks, test- ing it, debugging it, adopting its clients and API, using its Ul, keeping up with its ecosystem, etc.

Alt...

MVI (a better alternative) What I think is a better approach is to search for the minimum viable infrastructure (MVI): build the smallest amount of system while still providing value. 1. choose good-enough technology your org is already familiar with • good-enough == meets your users' needs without being too slow/expen- sive/insecure • familiar == your org has prior experi- ence, has runbooks/ops setups, moni- toring, Ul, etc 2. solve a real problem with it 3. use the minimum set of features • the fewer features you use, the more flexibility you have to move off the infra in question in the future (e.g if locked in with a vendor) Bonus points if that technology: • is widely adopted so finding good engineers for it is trivial (Postgres - check) • has a strong and growing network effect (Postgres - check)

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.

I have so many plans for PGConf.EU next week that I had to write them up as a blog post!

https://karenjex.blogspot.com/2025/10/getting-ready-for-pgconfeu-2025.html

What are you most looking forward to?

#Postgres #PostgreSQL #PGConfEU

Hey, @pgEdgeDistributedPostgres Spock multi-master replication has made it to the front page of Hacker News!

https://news.ycombinator.com/item?id=45533870

#PostgreSQL #Postgres #Database

What if Django had an automatic ORM feature matrix — showing which features each database really supports, straight from the code? 🧩

I’ve shared some ideas (with demo data!) on how it could work and why it’d be great for Django’s docs 💡

https://www.paulox.net/2025/10/06/django-orm-comparison/

CC @django

#Django #Python #ORM #OpenSource #Database #PostgreSQL #SQLite #MariaDB #MySQL

🎉 Django PostgreSQL Anonymizer v0.1.0b1 (Beta) is live!

Database anonymization for Django + PostgreSQL with role-based access, context managers, pre-built presets & comprehensive docs.

📦 pip install django-postgres-anonymizer==0.1.0b1
📚 https://django-postgres-anonymizer.readthedocs.io/
🐙 https://github.com/CuriousLearner/django-postgres-anonymizer

Looking for beta testers!

#Django #PostgreSQL #Python #DataPrivacy

#TIL Random ordering in Django. order_by('?') works but can be costly on large tables. Prefer order_by(Random()) (Django’s DB function) + LIMIT.

Notes + pitfalls inside. #Django #Python #ORM #PostgreSQL #Perf

https://til.sanyamkhurana.com/#/topics/django/random-ordering-with-order-by-in-django

Seeing slow queries + table bloat? Start with VACUUM to clear dead tuples, add ANALYZE to refresh stats, then consider VACUUM FULL only if you must. #PostgreSQL #QueryOptimization
https://til.sanyamkhurana.com/#/topics/psql/vacuum-analyze-in-postgresql

Interview with: Dian Fay | #PostgreSQL Person of the Week https://postgresql.life/post/dian_fay/

Tuning AIO in #PostgreSQL 18 https://vondra.me/posts/tuning-aio-in-postgresql-18/

Postgresql migrator pour passer de oracle ou mysql a postgresql

https://blog.dalibo.com/2025/09/29/postgresql-migrator-beta.html

#postgresql #opensource

PostgreSQL Migrator 1.0 en bêta https://www.journalduhacker.net/s/tc0peo/postgresql_migrator_1_0_en_b_ta https://blog.dalibo.com/2025/09/29/postgresql-migrator-beta.html #postgresql #sql

- https://postgresweekly.com/issues/617 Postgres 18 Released — Right on schedule comes the latest major version of Postgres. It's not one of Postgres's biggest steps forward, but has many notable changes to boost the performance of your database.

Some of what’s new:

- The introduction of an asynchronous I/O subsystem, allowing for more efficient scans, vacuuming, and more (https://www.cybertec-postgresql.com/en/postgresql-18-better-i-o-performance-with-aio/)

- UUIDv7 (https://www.thenile.dev/blog/uuidv7) support, along with several other new functions.

- https://www.cybertec-postgresql.com/en/postgresql-update-returning-made-even-better/ (UPDATE ... RETURNING) gets a notable improvement.

- Parallel apply of large transactions. (https://amitkapila16.blogspot.com/2025/09/parallel-apply-of-large-transactions.html)

- https://www.postgresql.org/docs/18/auth-oauth.html (OAuth 2.0 authorization and authentication)

# Other links

- https://pgpedia.info/postgresql-versions/postgresql-18.html (PostgreSQL 18 is the current PostgreSQL 2025-09-25)

- https://www.postgresql.org/docs/18/release-18.html (Release 18)

- https://www.postgresql.org/about/featurematrix/ (Feature matrix: this table outlines which features were added in which version)

#Postgresql #PostgreSQL18 #pgPedia

@mrmasterkeyboard @arnan if there's one thing I'd wish for, it's a #CLI / #TUI based "#Office Suite" with like:

• a #Markdown-centric #TextEditor,
• #TSV-centric #spreadsheets program,
• maybe a minimalist #PostgreSQL / #SQLite / #MariaDB client,
• #API tester (similar to #Postman),
• #neomutt-style #eMail client (with #PGP integration!) and
• maybe even some Image Viewer than can run entirely in #ASCII-#DEC or even #MDA terminal @ 80x24.

But that's just me wanting to be able to work entirely on @os13379one day...

https://mastodon.social/@mrmasterkeyboard/115256183525522481

We had a production outage on our Mastodon instance burningboard.net:

Root-cause analysis:

At around 16:23 today, the Linux OOMKiller did terminate two processes: java (Elasticsearch) and a PostgreSQL checkpoint process.

The termination of the pg checkpointer did put the database in a weird state (all connection attempts just saying "the database system is shutting down").

Immediate resolve:

pg_ctlcluster 17 main stop -m immediate
systemctl restart postgresql

Actions taken:
- Added 4GB of additional swap-space to the system
- Upgraded PostgreSQL to Version 18.0
- Added memory-limits in the systemd overrides for Elasticsearch

Everything operational again 🙂

#mastoadmin #mastodon #linux #postgresql #elasticsearch @tux

New #PostgreSQL release looks awesome, as usual 😍 https://digitalcourage.social/@sjstoelting/115265204287968909

Publication de PostgreSQL 18.0 : https://www.postgresql.org/about/press/presskit18/fr/
#PostgreSQL

- https://www.pycon.fr/2025/fr/talks/long-talk.html

- https://www.pycon.fr/2025/fr/talks/long-talk.html#:~:text=la%20suite%20numerique%2C%20la%20boite%20a%20outils%20collaborative%20open%20source%20de%20l'etat (La suite numérique, la boite à outils collaborative open source de l'Etat français)

par https://www.pycon.fr/2025/fr/speakers.html#:~:text=Adventures%20in%20Wonderland%20%C2%BB.-,manuel%20raynaud%20,-Libriste%20depuis%2020 (Manuel Raynaud)

--<--
Salle C436 − dimanche 2 novembre 2025 à 11:30 − 55 min

La Direction Interministériel du Numérique (DINUM) a entrepris de développer une suite collaborative, open source, pour rendre le travail des agents publics plus simple et plus efficace.

Cette suite collaborative est distribuée sous licence libre pour permettre à qui le souhaite de reprendre ses applications et de les intégrer dans les outils de son choix.

En participant à des communautés open source existantes, la suite numérique permet l'émergence de communs numériques qui facilitent l'indépendance pour ceux qui souhaitent la déployer et l'utiliser.

Conçue avec une approche modulaire, elle peut être adoptée partiellement, progressivement ou venir compléter une offre existante.

Je vous propose de vous présenter deux applications, aussi bien techniquement que fonctionnellement, qui sont intégrés dans cette suite collaborative

- Édition collaborative et documentation : La Suite Docs, basé sur Prosemirror et Blocknotejs. Développé conjointement avec l'Allemagne et la Hollande

- Partage de fichiers : Fichiers

Ces applications ont la même stack technique qui repose sur Python et le framework Django, Django REST Framework et PostgreSQL.

Au-delà d'une liste de librairies utilisées, je vous présenterai les process de qualité que nous avons mis en place, le workflow complet depuis l'idée d'une nouvelle feature à son implémentation et sa mise en production.

Je vous partagerai notre dev handbook (lui aussi sous licence libre) qui regroupe nos bonnes pratiques.

Comment ce qui pourrait être qualifié de « Borng Stack » (comprendre « éprouvé et battle testé ») nous permet de nous focaliser sur la résolution de problématiques complexes.

-->--

#communs_numériques #python #lyon #pyconfr2025 #dinum #france #LogicielLibre #SuiteNumérique #postgresql

Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in #Django with #PostgreSQL | Caktus Group https://www.caktusgroup.com/blog/2025/06/16/avoiding-timezone-traps-correctly-extracting-datetime-subfields-django-postgresql/

PostgreSQL Hebdo #122 : https://sebastien.lardiere.net/blog/index.php/post/2025/09/19/PostgreSQL-Hebdo-122
#PostgreSQL

There will be a #PostgreSQL meetup in #toulouse on october the 9th 18h30 in the #pictarine office (Labège innopole).

Agenda soon published.

Retoot appreciated!

On relance les meetups #PostgreSQL à #toulouse. Ce sera le 9 octobre à 18h30 dans les locaux de #pictarine à Labège Innopole.

Le programme sera bientôt publié.

Le repouet optimise vos requêtes SQL !

@caravantraveller @brooke

This "deprecation" was never visible at any level, there's no discovery path for anyone that found or otherwise used these and stuck with it.

But none of that matters: The most recent Debian 12 installer still unavoidably selects US/Pacific for people living there, today.

https://rachelbythebay.com/w/2025/09/12/tz/

Lobsters: https://lobste.rs/s/okz9ir/debian_12_installer_promotes_us_time

#tzdata #timezones #datetime #Postgres #PostgreSQL #RachelByTheBay

If you're running Debian 12 and Postgres, you're in or around the Americas, and you're planning on upgrading to Debian 13, you might hit a fun little snag [..]

https://rachelbythebay.com/w/2025/09/11/debtz/

#tzdata #timezones #datetime #Postgres #PostgreSQL #RachelByTheBay

Elizabeth Garrett Christensen is delivering the talk "Big Bad World of Postgres Dev Environments" at the DjangoCon US 2025 in Chicago 🇺🇸🐘

CC @djangocon @pgus @sqlliz

#Django #DjangoCon #DjangoConUS #DjangoConUS2025 #PostgreSQL #Postgres

Alt...

Speaker on stage

Alt...

Speaker on stage

Alt...

Speaker on stage

Alt...

Speaker on stage

This morning I presented my talk "Django's Generated Field by Example" at DjangoCon US 2025 in Chicago. 🇺🇸

Thanks to all the attendees for filling the room and for all the interesting questions. 🤗

You can find the slides on my website. 👇
https://www.paulox.net/2025/09/08/djangocon-us-2025/

Photo of the talk by Muhammad Abdugafarov

CC @djangocon

#Django #DjangoCon #DjnagoConUS #DjangoConUS2025 #GeneratedField #GeneratedColumn #PostgreSQL #SQLite

Alt...

Speaker on stage

Alt...

Attendees

Alt...

Speaker with talk manager

Alt...

Speaker on stage

- https://postgr.es/p/7bo (PgPedia Week, 2025-08-24)

- PostgreSQL 19 changes this week
- Blogs, podcasts, newsletters etc

#PostgreSQL19 #PostgreSQL #documentation

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

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

Upgraded a PostgreSQL server from Debian 12 to 13, and got hit by this bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789

resutling in the new postgresql version running with the wrong configuration after running pg_upgradecluster.

#Debian #Trixie #debian13 #PostgreSQL #bug

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