#postgresql18 — Public Fediverse posts

Update: NetBSD works fine with #postgreSQL18 and the PostGIS extension by adding 18 to the Makefile and compiling/installing the databases/postgresql-postgis2 package.

$ diff Makefile*
44,45c44
< # PGSQL_VERSIONS_ACCEPTED= 17 16 15 14
< PGSQL_VERSIONS_ACCEPTED= 18 17 16 15 14
---
> PGSQL_VERSIONS_ACCEPTED= 17 16 15 14

I should test 14 before filing a fix.

Edit: tested PGSQL 14, filed a problem report, got positive feedback. Bunch of work to add a version number to a Makefile. :)

Update: NetBSD works fine with #postgreSQL18 and the PostGIS extension by adding 18 to the Makefile and compiling/installing the databases/postgresql-postgis2 package.

$ diff Makefile*
44,45c44
< # PGSQL_VERSIONS_ACCEPTED= 17 16 15 14
< PGSQL_VERSIONS_ACCEPTED= 18 17 16 15 14
---
> PGSQL_VERSIONS_ACCEPTED= 17 16 15 14

I should test 14 before filing a fix.

Edit: tested PGSQL 14, filed a problem report, got positive feedback. Bunch of work to add a version number to a Makefile. :)

As the #FreeBSD pkg of the postgis extension is not tied to a database version and the #NetBSD one seems to be, I moved the geo databases to the former. The rest, to NetBSD.
Zabbix, on the other hand, might need to be a little more performant. We'll see.

1204605:20260608:155730.445 slow query: 6.477221 sec, [...]

Plan is to move Zabbix back to the faster machine when #PostgreSQL18 is set.

(15 minutes down time for export, copy, import, restart).

Edit: DB server heat chart. 80 C until done.

As the #FreeBSD pkg of the postgis extension is not tied to a database version and the #NetBSD one seems to be, I moved the geo databases to the former. The rest, to NetBSD.
Zabbix, on the other hand, might need to be a little more performant. We'll see.

1204605:20260608:155730.445 slow query: 6.477221 sec, [...]

Plan is to move Zabbix back to the faster machine when #PostgreSQL18 is set.

(15 minutes down time for export, copy, import, restart).

Edit: DB server heat chart. 80 C until done.

Note to self: use pgsql client 18 to list server version 18 databases, as client 16 fails, understandably.

$ psql -U dbuser -d db18 -h host --list
ERROR: column d.daticulocale does not exist
LINE 8: d.daticulocale as "ICU Locale",
^
HINT: Perhaps you meant to reference the column "d.datlocale".

#PostgreSQL18

Note to self: use pgsql client 18 to list server version 18 databases, as client 16 fails, understandably.

$ psql -U dbuser -d db18 -h host --list
ERROR: column d.daticulocale does not exist
LINE 8: d.daticulocale as "ICU Locale",
^
HINT: Perhaps you meant to reference the column "d.datlocale".

#PostgreSQL18

Started looking at upgrading databases to #PostgreSQL18 on NetBSD and then remembered the PostGIS add-on. Looks like that package (named postgresql-postgis2 though it's v3.6 or so) isn't workable for PGSQL18.

# grep PGSQL_VERSIONS_ACCEPTED Makefile
PGSQL_VERSIONS_ACCEPTED= 17 16 15 14

Next stop: wip (work in progress).

Started looking at upgrading databases to #PostgreSQL18 on NetBSD and then remembered the PostGIS add-on. Looks like that package (named postgresql-postgis2 though it's v3.6 or so) isn't workable for PGSQL18.

# grep PGSQL_VERSIONS_ACCEPTED Makefile
PGSQL_VERSIONS_ACCEPTED= 17 16 15 14

Next stop: wip (work in progress).

Once again, I tried to pull a zabbix server out of a hat and voila it only supports mysql, so I got a new ports tree and rebuilt from source. I feel like a goldfish sometimes.
Upgrade now supports #PostgreSQL18

Once again, I tried to pull a zabbix server out of a hat and voila it only supports mysql, so I got a new ports tree and rebuilt from source. I feel like a goldfish sometimes.
Upgrade now supports #PostgreSQL18

https://public.dalibo.com/exports/formation/manuels/modules/menu/menu.slides.reveal.html

Sommaire des formations DALIBO
Sommaire des formations
Dalibo SCOP
12 mai 2026

#dalibo #postgresql #postgresql18

https://public.dalibo.com/exports/formation/manuels/modules/menu/menu.slides.reveal.html

Sommaire des formations DALIBO
Sommaire des formations
Dalibo SCOP
12 mai 2026

#dalibo #postgresql #postgresql18

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

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

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

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

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

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

#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'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

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 via @boringsql.

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

#PostgreSQL #PostgreSQL18 #ZFS #XFS #APFS

🚀 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

🚀 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

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

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

Instant database clones with PostgreSQL 18

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

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

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

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

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

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

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

🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated

🚀🎉 Wow, groundbreaking revelation! PostgreSQL 18 can multitask like a teenager texting, eating, and ignoring chores simultaneously. Who knew #pipelining was the secret sauce to sending queries faster than your cat ignoring you? 🐱📚
https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html #PostgreSQL18 #multitasking #database #innovation #technology #HackerNews #ngated

Looking for an open-source, versatile database engine (or thinking about upgrading an existing instance)?

#PostgreSQL is a great solution; it's recommended to upgrade to the latest major version - 1 to ensure stability, and PG17 is a powerful release that brought major improvements to performance, logical replication, & more.

Read about it: https://www.pgedge.com/blog/postgresql-17-a-major-step-forward-in-performance-logical-replication-and-more

#pg18 #postgresql18 #postgres #programming #code #developer #devops #dba #datascience #database #foss #oss #opensource #tech

Looking for an open-source, versatile database engine (or thinking about upgrading an existing instance)?

#PostgreSQL is a great solution; it's recommended to upgrade to the latest major version - 1 to ensure stability, and PG17 is a powerful release that brought major improvements to performance, logical replication, & more.

Read about it: https://www.pgedge.com/blog/postgresql-17-a-major-step-forward-in-performance-logical-replication-and-more

#pg18 #postgresql18 #postgres #programming #code #developer #devops #dba #datascience #database #foss #oss #opensource #tech

Now that #PostgreSQL18 has been released, it's a great time to learn about and experiment with #PostgreSQL Cumulative Statistics - an excellent feature that gives extension developers support for defining new statistics.

Learn more about stats (similar to what's in pg_stat* views & functions) and how to define your own views & functions in the future from @c2main:
https://mirrors.dotsrc.org/fosdem/2025/ua2220/fosdem-2025-4496-stats-roll-baby-stats-roll-.mp4

@fosdem #FOSDEM2025 #postgres #programming #coding #tech #developer #sql #data #learning #pg18 #statistics

Now that #PostgreSQL18 has been released, it's a great time to learn about and experiment with #PostgreSQL Cumulative Statistics - an excellent feature that gives extension developers support for defining new statistics.

Learn more about stats (similar to what's in pg_stat* views & functions) and how to define your own views & functions in the future from @c2main:
https://mirrors.dotsrc.org/fosdem/2025/ua2220/fosdem-2025-4496-stats-roll-baby-stats-roll-.mp4

@fosdem #FOSDEM2025 #postgres #programming #coding #tech #developer #sql #data #learning #pg18 #statistics

#PostgreSQL18 transforme le sous-système de statistiques. Exemples:

✨ Statistiques I/O en octets au lieu de pages
✨ Nouvelle API C pour les extensions
✨ Visibilité I/O par backend avec pg_stat_get_backend_io()

La vraie nouveauté pour les développeurs d'extensions: vous pouvez maintenant utiliser l'API de statistiques cumulatives de #PostgreSQL. Exportez, importez et ajustez les stats à volonté.

https://www.data-bene.io/fr/blog/statistiques-cumulatives-dans-postgresql-18

#programmation #developpeur #technologie #Postgres #pg18 #informatique

🎉🎩 Ah, PostgreSQL 18: the version where we finally get excited about asynchronous IO, as if databases haven’t been doing it for decades. But don't worry, no details or benchmarks here, just a riveting suggestion to watch a talk from 2025. 🌟🔮
https://vondra.me/posts/tuning-aio-in-postgresql-18/ #PostgreSQL18 #AsynchronousIO #DatabaseTalks #FutureTech #HackerNews #ngated

🎉🎩 Ah, PostgreSQL 18: the version where we finally get excited about asynchronous IO, as if databases haven’t been doing it for decades. But don't worry, no details or benchmarks here, just a riveting suggestion to watch a talk from 2025. 🌟🔮
https://vondra.me/posts/tuning-aio-in-postgresql-18/ #PostgreSQL18 #AsynchronousIO #DatabaseTalks #FutureTech #HackerNews #ngated

#PostgreSQL18 brings major changes to the statistics ecosystem, like:

✨ pg_upgrade retains the optimizer stats (a welcome change!)
✨ Statistics I/O in bytes instead of pages
✨ New C API for extensions
✨ I/O visibility by backend with pg_stat_get_backend_io()
✨ Better insights for conflict management

Notably, you can now use the #PostgreSQL Cumulative Statistics API. Export, import and adjust stats at will.

Learn more in our latest blog from @c2main https://www.data-bene.io/en/blog/cumulative-statistics-in-postgresql-18

#tech #programming

#PostgreSQL18 brings major changes to the statistics ecosystem, like:

✨ pg_upgrade retains the optimizer stats (a welcome change!)
✨ Statistics I/O in bytes instead of pages
✨ New C API for extensions
✨ I/O visibility by backend with pg_stat_get_backend_io()
✨ Better insights for conflict management

Notably, you can now use the #PostgreSQL Cumulative Statistics API. Export, import and adjust stats at will.

Learn more in our latest blog from @c2main https://www.data-bene.io/en/blog/cumulative-statistics-in-postgresql-18

#tech #programming

Upgrading from PostgreSQL v17 to v18. 🚀 Using the pg_upgradecluster command if you want to know.

Just be sure you have enough RAM memory & storage left during such an upgrade. If needed increase your huge pages numbers (in case you enabled huge pages). 🤞 #postgresql #postgresql18 #upgrade #server

https://www.postgresql.org/about/news/postgresql-18-released-3142/

Upgrading from PostgreSQL v17 to v18. 🚀 Using the pg_upgradecluster command if you want to know.

Just be sure you have enough RAM memory & storage left during such an upgrade. If needed increase your huge pages numbers (in case you enabled huge pages). 🤞 #postgresql #postgresql18 #upgrade #server

https://www.postgresql.org/about/news/postgresql-18-released-3142/

RE: https://mastodon.social/@pgEdgeDistributedPostgres/115142577862912902

#PostgreSQL18 coming out next week - have you taken a look at new and upcoming features yet?

#technews #tech #oss #foss #opensource

RE: https://mastodon.social/@pgEdgeDistributedPostgres/115142577862912902

#PostgreSQL18 coming out next week - have you taken a look at new and upcoming features yet?

#technews #tech #oss #foss #opensource

As part of our upcoming Perspectives on PostgreSQL 18 series, Floor Drees sat down with Bruce Momjian and Tom Kincaid to talk about the role of community in every release.

In this clip, Bruce explains why open source works like a democracy and why a healthy project is like a magnifying glass that amplifies the impact of every contributor 🔎

#PostgreSQL18 #PG18 #Postgres #OpenSource #PGCommunity

As part of our upcoming Perspectives on PostgreSQL 18 series, Floor Drees sat down with Bruce Momjian and Tom Kincaid to talk about the role of community in every release.

In this clip, Bruce explains why open source works like a democracy and why a healthy project is like a magnifying glass that amplifies the impact of every contributor 🔎

#PostgreSQL18 #PG18 #Postgres #OpenSource #PGCommunity

#postgres 18 will support #OAuth2—exciting! My use case: editing #geodata in #QGIS with #PostGIS. Most #orgs use single-sign-on #sso , but #PostGIS editing still requires separate passwords. OAuth2 could simplify this process
#postgresql #postgresql18
https://www.crunchydata.com/blog/get-excited-about-postgres-18#oauth-20

#postgres 18 will support #OAuth2—exciting! My use case: editing #geodata in #QGIS with #PostGIS. Most #orgs use single-sign-on #sso , but #PostGIS editing still requires separate passwords. OAuth2 could simplify this process
#postgresql #postgresql18
https://www.crunchydata.com/blog/get-excited-about-postgres-18#oauth-20

🔍 Want full-text search in any language with #postgresql18

Watch Vee Satayamas present a powerful extension that breaks language barriers—bringing advanced search to multilingual applications with ease.

🎥 Click here: https://youtu.be/C6o71HQXTaQ

🔍 Want full-text search in any language with #postgresql18

Watch Vee Satayamas present a powerful extension that breaks language barriers—bringing advanced search to multilingual applications with ease.

🎥 Click here: https://youtu.be/C6o71HQXTaQ

#PostgreSQL18 permettra d'optimiser encore plus les requêtes.
Guillaume aborde une fonctionnalité introduite par la version 9.0 et améliorée depuis la semaine dernière : la **suppression de jointures inutiles**.

=> https://dali.bo/202503_jointures

#PostgreSQL
#SGBD #DBA
#opensource #logicielsLibres

Où l'on aborde la clause RETURNING, qui permet de récupérer des informations sur les lignes de table insérées, modifiées ou supprimées. Cette fonctionnalité a été améliorée dans #PostgreSQL18
=> https://dali.bo/202501_returning

#PostgreSQL #SGBD #DBA
#opensource #logicielsLibres