ERROR: extension "timescaledb" has no installation script nor update path for version "2.21.0

[bataliero]

Hi
I tried to run the example with

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: example
spec:
  instances: 3
  imageName: ghcr.io/clevyr/cloudnativepg-timescale:17-ts2
  postgresql:
    shared_preload_libraries:
      - timescaledb
  bootstrap:
    initdb:
      postInitTemplateSQL:
        - CREATE EXTENSION IF NOT EXISTS timescaledb;

But I get:

initdb {"level":"error","ts":"2025-07-23T09:07:36.73964686Z","msg":"Error while bootstrapping data directory","logging_pod":"my-timeseries-db-1-initdb","error":"while configuring new instance: could not execute init Template queries: ERROR: extension \"timescaledb\" has no installation script nor update path for version \"2.21.0\" (SQLSTATE 22023)","stackt 
initdb Error: while configuring new instance: could not execute init Template queries: ERROR: extension "timescaledb" has no installation script nor update path for version "2.21.0" (SQLSTATE 22023)                                                                                                                                                                 

Image pinning to e.g ghcr.io/clevyr/cloudnativepg-timescale:17.5-17-ts2.19.3 did not help either. I see same issue

Thank for help!

[olexiyb]

I have had the same issue, I was able to solve it using different approach cloudnative-pg/charts#414

[usersina]

Here's how I fixed it:

apiVersion: postgresql.cnpg.io/v1
kind: ClusterImageCatalog
metadata:
  name: timescale
  namespace: default
spec:
  images:
    - major: 17
      image: timescale/timescaledb:2.21.1-pg17 # https://hub.docker.com/layers/timescale/timescaledb/2.21.1-pg17/images/sha256-1dd747e5737ca738ca8dfc234fbf6ed42d9060f5fb2fd305922633503133c32a
---
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: pg-timescale
  namespace: default
spec:
  instances: 1
  imageCatalogRef:
    apiGroup: postgresql.cnpg.io
    kind: ClusterImageCatalog
    name: timescale
    major: 17
  postgresql:
    shared_preload_libraries:
      - timescaledb
  postgresUID: 70 # see below
  postgresGID: 70 # see below
  bootstrap:
    initdb:
      postInitTemplateSQL:
        - CREATE EXTENSION IF NOT EXISTS timescaledb;
  # storage:
  #   storageClass: local-path
  #   size: 10Gi

You can get the value to use for postgresUID and postgresGID using docker run --rm timescale/timescaledb:2.21.1-pg17 getent passwd postgres, else you would get a data volume permission issue.

[ronnyhel]

Can you configure barman on
timescale/timescaledb:2.21.1-pg17?

[Pivert]

The problem is that the available scripts are for version up to 2.19.3 in the image.
If you:
CREATE EXTENSION timescaledb VERSION '2.19.3';

It should work.

The Dockerfile might need a fix to include later scripts...

[alq-eium]

Hi @usersina thank you for your approach! It has helped me to solve data volume permission. However, I still haven’t tested all the functionalities, and I’d like to know whether you’ve encountered any limitations with your approach. My question comes up because the image you’re using is the official TimescaleDB image. But, the CloudNativePG documentation and tutorials suggest starting from a CloudNativePG base image and adding the extensions on top of that image.

Best regards,
Alejandro