timescaledb_toolkit in the 5.0 Operator

[jhualpa]

I have the requirement to use timescaledb_toolkit(https://docs.timescale.com/timescaledb/latest/how-to-guides/hyperfunctions/install-toolkit/) on top of timescaledb on a cluster running Crunchy PostgreSQL for Kubernetes.
I thought with this lines will work:

patroni:
    dynamicConfiguration:
      postgresql:
        parameters:
          shared_preload_libraries: 'timescaledb,timescaledb_toolkit'
          timescaledb.license: apache

However timescaledb_toolkit extension is not installed as part of Crunchy PostgreSQL for Kubernetes so I get an error, so is there any way to install it on a running cluster ? Has somebody been through a similar situation of not having an extension needed on the images ? Should I create my own image based on https://github.com/CrunchyData/crunchy-containers/blob/master/build/postgres/Dockerfile#L52 and add the extension I need ?

[dsessler7]

@jhualpa, as of right now, you would need to build your own image to get his to work. That being said, we do have a story in our dev backlog for adding support for the TimescaleDB Toolkit.

[oliviasculley]

We ran into this as well, because our Rails application was including CREATE EXTENSION IF NOT EXISTS timescaledb_toolkit WITH SCHEMA public; since the local db was set up with the official timescale/timescaledb-ha:pg17 image and it was trying to recreate that in crunchydata with that schema. Disabling that line in structure.sql worked well, but it would be nice to have access to those additional hyperfunctions and whatnot