Dalibo1d ago

FORMATION : ajouts de TP, correctifs et revue des cours en intégrant les nouveautés de #PostgreSQL18… les manuels Dalibo viennent d'être mis à jour => https://dali.bo/202605_manuels

Toujours en accès libre sous format html, pdf, ePub, et slides. 👀

Merci à nos collègues #DBA pour leur travail ! 💐

#opensource #SGBD #SQL #formation #PostgreSQL

Éditions D-BookeRMar 19

PostgreSQL 18 saute la case imprimeur.

La 6e édition du livre "PostgreSQL — Architecture et notions avancées" (Guillaume Lelarge & Julien Rouhaud) paraît aujourd'hui en numérique, sur les traces de la version 18.

Pour les irréductibles du papier, la 5e édition (PostgreSQL 16) reste une valeur sûre.

👉 https://dbkr.fr/livre-pg6

#PostgreSQL #OpenSource #DBA #BaseDeDonnées #PostgreSQL18

@dalibo

DaliboJan 13

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

pgEdge PostgresJan 6

#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.

Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applications

Perfect for devs & database architects looking to maximize PG18's capabilities.

Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications

#PostgreSQL18 #OpenSource #Postgres

PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications

PostgreSQL 18 has arrived with some fantastic improvements, and among them, the RETURNING clause enhancements stand out as a feature that every PostgreSQL developer and DBA should be excited about. In this blog, I'll explore these enhancements, with particular focus on the MERGE RETURNING clause enhancement, and demonstrate how they can simplify your application architecture and improve data tracking capabilities.

joschiDec 23

Instant database clones with PostgreSQL 18 via @boringsql.

https://boringsql.com/posts/instant-database-clones/

#PostgreSQL #PostgreSQL18 #ZFS #XFS #APFS

Instant database clones with PostgreSQL 18

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

boringSQL | Supercharge your SQL & PostgreSQL powers
N-gated Hacker NewsDec 23
🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦‍♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated
Instant database clones with PostgreSQL 18

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

boringSQL | Supercharge your SQL & PostgreSQL powers
Hacker NewsDec 23

Instant database clones with PostgreSQL 18

https://boringsql.com/posts/instant-database-clones/

#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL

Instant database clones with PostgreSQL 18

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

boringSQL | Supercharge your SQL & PostgreSQL powers
credativ GmbHDec 15

Neuer Blogpost: PostgreSQL 18 führt asynchrone Festplatten-E/A ein.
Wir geben einen detaillierten Einblick in die Implementierung und die technischen Hintergründe.

https://www.credativ.de/blog/postgresql/postgresql-18-asynchrone-festplatten-e-a-detaillierter-einblick-in-die-implementierung/

#PostgreSQL18 #credativ #opensource #postgresql

Carl von LesquereuxNov 4, 2025

Aparentemente se les fue la olla a los de #Fedora con la actualización a #Fedora43 si se tiene instalado #PostgreSQL.

#Fedora42 trae #PostgreSQL_16, mientras que la v43 trae #PostgreSQL_18. Entonces, al actualizar el SO, todo peta, porque no puedes usar `postgresql-setup --upgrade`, ya que tu cluster es v16 y el upgrade sólo sirve de v17 a v18.

Más info y solución, aquí: https://discussion.fedoraproject.org/t/cant-upgrade-postgres-after-f42-f43/171071/4

#Linux #Databases #PostgreSQL16 #PostgreSQL18 #PostgreSQL17

Can't upgrade postgres after f42->f43

Unfortunately there are a few issues. Fedora does not allow to install multiple versions of Postgres, which makes this a bit more complicated. Luckily the postgres-upgrade packages include the “old” (n-1) binaries. There are a few options available how to do the upgrade. I am trying to find a nice solution that is the least error prone. e.g. if you are not careful you might end up with things like old cluster does not use data checksums but the new one does. An upgrade always replaces your c...

Fedora Discussion
Hacker NewsOct 17, 2025

Exploring PostgreSQL 18's new UUIDv7 support

https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support

#HackerNews #PostgreSQL #UUIDv7 #UUIDs #DatabaseTech #PostgreSQL18 #AivenBlog

Exploring PostgreSQL 18's new UUIDv7 support

Exploring what's interesting about UUIDv7 support using a demo crab store.

Aiven