[Feature request]: pg_trgm postgres extension should be added if not present

[jessereynolds]

Use Case

It would be nice to have the container init check if pg_trgm extension is present in postres and if not enable it.

For example, when using the crafy oss compose example with the docker.io/postgres:18-alpine container, starting the openvoxdb container fails with:

2026-02-02 14:32:18,202 ERROR [p.p.s.migrate] PuppetDB requires the PostgreSQL `pg_trgm` extension.
Please connect to the PuppetDB database and run this:
    CREATE EXTENSION pg_trgm;

Describe the solution you would like

I'm not sure where this should be implemented:

• additional initialisation script added to this container
• steps added to crafty's examples
• deritative postgresql image that includes the extension

Or just be added to documentation in this project.

Describe alternatives you've considered

No response

Additional context

No response

[jessereynolds]

Adding the extension to the openvoxdb database:

connect (eg using compose):

podman-compose --profile openvox exec postgres psql -h postgres -U openvoxdb

First check if it's available to be added:

openvoxdb=# select * from pg_available_extensions where name = 'pg_trgm';
  name   | default_version | installed_version |                              comment
---------+-----------------+-------------------+-------------------------------------------------------------------
 pg_trgm | 1.6             |                   | text similarity measurement and index searching based on trigrams
(1 row)

if so, add it:

openvoxdb=# create extension pg_trgm;
CREATE EXTENSION
openvoxdb=#