pg_dump version mismatch

[prabhakarreddy1234]

i provisioned backup cronjob on my AKS cluster. I'm running Postgres 11.5 on my AKS cluster. When the job runs i 'm seeing this error message.

Creating dump: backupOn2020-02-10-23-57.dump
pg_dump: server version: 11.5 (Debian 11.5-3.pgdg90+1); pg_dump version: 9.6.10
pg_dump: aborting because of server version mismatch
Back up not created, check db connection settings

I'm using rinormaloku/postgres-back-up image. Is there anyway i can update the image to support Postgres 11.5 ?

[rinormaloku]

Hi @prabhakarreddy1234

Sorry for missing this question. I hope you were able to find a solution. I'll provide a response so that if others have the same question, they can spare time of finding out how.

The alpine image needs to be updated so that a new version of PostgreSQL can be pulled. For the 11 version of PostgreSQL, it would have been alpine v3.10.

You can check all the versions of the packages available in Alpine Linux Repository: https://pkgs.alpinelinux.org/packages?name=postgresql&branch=v3.10

[mlabrum]

Thanks @rinormaloku for creating this, I've just published https://hub.docker.com/repository/docker/mlabrum/postgres-back-up which uses an updated alpine image.

[rinormaloku]

Great @mlabrum,

Thanks for dropping it here! ✌️