Custom Spilo image for the Zalando Postgres Operator with vchord

[AlexanderBabel]

Hey everyone,

I recently switched my immich instance to the Zalando Postgres Operator inside my Kubernetes cluster.

Unfortunately, the Postgres image used by Zalando (called spilo) didn't include the vchord extension. Hence, I built my own version that includes the latest version of vchord.

You can find the custom image on my public repo. I try to keep it up to date with the latest vchord/spilo versions and appreciate PRs if I might miss a new version.

Here is an example PostgreSQL manifest to deploy a database that can be used right away with immich:

apiVersion: acid.zalan.do/v1
kind: postgresql
metadata:
  name: postgresql-immich
  namespace: database
spec:
  numberOfInstances: 1
  dockerImage: ghcr.io/alexanderbabel/spilo:4.0-p3
  postgresql:
    version: "17"
    parameters:
      shared_preload_libraries: vchord
  preparedDatabases:
    immich:
      defaultUsers: true
      extensions:
        earthdistance: public
        uuid-ossp: public
        unaccent: public
        cube: public
        pg_trgm: public
        plpgsql: public
        vector: public
        vchord: public
      schemas:
        public: {}
      secretNamespace: immich
  resources:
    limits:
      cpu: 2000m
      memory: 2Gi
    requests:
      cpu: 50m
      memory: 512Mi
  teamId: prod
  volume:
    size: 10Gi

[sdwilsh]

How did you migrate from pgvecto.rs? I have left myself on an old version of immich because I haven't had time to figure out how to migrate.

[AlexanderBabel]

Hey @sdwilsh,

you can follow the migration guide from immich's documentation. The section Migration steps (manual) includes necessary queries to execute for the switch to vchord without needing both extensions present.

[sdwilsh]

I'm familiar with the guide, but it says you need an image with both extensions installed. Your image only includes vchord, right?

[bo0tzz]

@sdwilsh check the section below that, it's possible without as well.

[sdwilsh]

Wild that I missed that, but thanks for pointing it out!