PostgreSQL 18 recently gained a way to load extensions from different directories. The CNPG Kubernetes operator pioneers using these images. It would be great to build this container image on release.
Some documentation can be found at
https://cloudnative-pg.io/documentation/1.28/imagevolume_extensions/
I might be able to contribute CI integration to automatically push such an image.