Unable to perform BBR backup with Concourse 7.12.
Article ID: 410168
Updated On:
Products
Issue/Introduction
Running a BBR backup of a Concourse 7.12 deployment fails due to a missing package postgres-backup-restorer-11.
Environment
Concourse 7.12
Cause
The bbr-atcdb backup script comes from the Concourse bosh release, that is the code that is looking for database-backup-restorer-postgres-11. The release that provides the package is the backup-and-restore-sdk-release. Support for Postgres 11 was removed October of 2024, likely due to this version being out of support and no longer receiving security patches.
Resolution
The workaround to resolve this issue is to install an older backup and restore sdk release before Postgres-11 was removed.
Backup and restore version v1.19.36(release link) is the last release with Postgres-11 support.
Note: The choice on which older version of the backup and restore sdk will depend on what other releases, and database versions are involved.
Additional Information
There is a PR that has been recently merged that will resolve this issue once it is pushed for release for public consumption.
Corrected handling of PostgreSQL version default in ERB template
Feedback
