BBR Backup Fails for Concourse 7.12.x / 7.13.x with PostgreSQL 16.x

Products

• Concourse for VMware Tanzu

Issue/Introduction

When attempting to perform a BOSH Backup and Restore (BBR) backup of Concourse versions 7.12.x or 7.13.2 configured with a PostgreSQL 16.x backing database, the backup process fails.

The failure presents different error messages depending on the backup-and-restore-sdk-release (BBR-SDK) version in use:

• Under BBR-SDK 1.19.45:
  

  /var/vcap/packages/database-backup-restorer-postgres-11/bin/psql: No such file or directory (exit code 127)

• Under BBR-SDK 1.19.36 (the last version including the postgres-11 package):
  

  unsupported version of postgresql: 16.x

Environment

 

Issue confirmed on below versions:-

• Concourse Versions: 7.12.x, 7.13.2

• Backing Database: PostgreSQL 16.x

• BBR-SDK Versions: 1.19.36, 1.19.45

 

Cause

The Concourse BBR job directly invokes the psql binary that is packaged inside the BBR release. The failure is due to a compatibility gap regarding PostgreSQL 16.x support in the BBR-SDK releases associated with these Concourse versions:

1. Older BBR versions (like 1.19.36) contain the necessary binaries but explicitly do not support PostgreSQL 16.x.
2. Newer BBR versions (like 1.19.45) have dropped the older postgres-11 packages that Concourse 7.x attempts to reference, leading to a "No such file or directory" error.

Consequently, BBR backups cannot be completed natively on Concourse 7.12.x/7.13.2 when using a PostgreSQL 16.x database.

Resolution

Permanent Fix:-
The permanent fix is to upgrade Concourse to v8.0.2 with backup-and-restore-sdk-release v1.19.51.

If upgrading to Concourse v8.0.2(with backup-and-restore-sdk-release v1.19.51) is not immediately feasible then please contact Broadcom support.