search

kartoza / docker-pg-backup

A cron job that will back up databases running in a docker postgres container
GNU General Public License v2.0
452 stars 103 forks source link

add reference version 9.6 for postgresql-client #34

Closed sumandari closed 3 years ago

sumandari commented 3 years ago

When I did build the image in branch 9.6 come with psql version 9.6.19 installed, I got pg_dump version 13.0 instead of 9.6. Hence dump file generated will raise an error when I restore to a container with psql and pg_dump version 9.6 in it.

$ docker exec  projecta-db-backups /bin/sh -c "pg_dump --version"
pg_dump (PostgreSQL) 13.0 (Debian 13.0-1.pgdg100+1)

This PR adds a version reference to postgresql-client in Dockerfile to ensure that the pg_dump installed is version 9.6.

$ docker exec projecta-db-backups /bin/sh -c "psql --version"
psql (PostgreSQL) 9.6.19
$ docker exec projecta-db-backups /bin/sh -c "pg_dump --version"
pg_dump (PostgreSQL) 9.6.19