Failure to create Citus clusters based on Postgres 13
Summary
It is not possible to create a Citus cluster through the SGShardedCluster CRD if the Postgres version is 13
Current Behaviour
If I attempt to create a SGShardedCluster based on Postgres 13, I am greeted with the following error:
Error from server (https://stackgres.io/doc/1.5/api/responses/error#extension-not-found): error when creating "test-citus.yaml": admission webhook "sgshardedclusters.stackgres.default" denied the request: Some extensions were not found: citus 11.3-1 (available 11.0-4, 11.3-1, 11.0-2, 10.2.5, 11.1-1, 11.0.5, 10.1-1, 11.2-2, 11.2-1, 10.2-5, 10.2-4), citus_columnar 11.3-1 (available 11.2-1, 11.1-1, 11.3-1)
This happens both through the web UI and the CLI
Steps to reproduce
Here's the minimal yaml that works:
apiVersion: stackgres.io/v1alpha1
kind: SGShardedCluster
metadata:
namespace: stackgres
name: citus
spec:
type: citus
database: main
postgres:
version: '13.11'
coordinator:
instances: 1
pods:
persistentVolume:
size: '10Gi'
shards:
clusters: 2
instancesPerCluster: 1
pods:
persistentVolume:
size: '10Gi'
prometheusAutobind: true
Merely replacing '13.11' with any 14.x or 15.x version makes it work.
Expected Behaviour
The admission webhook accepts this SGShardedCluster definition
Possible Solution
Sorry, my java-fu is weak
Environment
- StackGres version: 1.5.0 (via helm)
- Kubernetes version: 1.27
- Cloud provider or hardware configuration: EKS-based cluster