zammad-backup not working with postgres 17

[krombel]

After upgrading to the latest release backups are not working anymore.

These are the logs of the zammad-backup container:

zammad-backup-1  | 20241115163509 - backing up zammad...
zammad-backup-1  | tar: Removing leading `/' from member names
zammad-backup-1  | pg_dump: error: aborting because of server version mismatch
zammad-backup-1  | pg_dump: detail: server version: 17.1; pg_dump version: 15.8 (Debian 15.8-0+deb12u1)
zammad-backup-1  | backup finished :)
zammad-backup-1  | sleeping 37490 seconds until the next backup run...

It seems, this issue is coming from the ruby base image:
https://github.com/zammad/zammad/blob/6.4.0/Dockerfile#L20
where then the postgres-client package is installed
https://github.com/zammad/zammad/blob/6.4.0/contrib/docker/setup.sh#L7

This is currently based on bookworm - which does not have postgres-client for postgres 17 yet.
https://packages.debian.org/search?keywords=postgresql-client

[mgruner]

Confirmed, fix is in the works: zammad/zammad#5416

[mgruner]

@skyscooby our upgrading instructions for docker advise to check the release notes for zammad-docker-compose. I assume you didn't read these?

I have to admit that we need to improve our workflows and CI coverage, but it's not true that operational concerns are discarded.