Concourse BBR backup fails with server certificate psql does not match host name

Products

• Concourse for VMware Tanzu
• Pivotal Concourse

Issue/Introduction

Concourse BBR backups could fail with the below error if the correct property is not defined in the manifest.

psql: server certificate for "postgresql.fqdn.concourse.bosh" does not match host name "10.20.30.40" - exit code 2

Resolution

To resolve the error, the below properties need to be added to the concourse manifest.

Retrieve the concourse manifest.
bosh -d Your_Concourse_Deployment manifest > Concourse_Manifest.yaml

Edit the Concourse_Manifest.yaml file by adding the below options.

- name: bbr-atcdb
  release: concourse
  properties:
    postgresql:
      host: postgresql.fqdn.concourse.bosh
      port: 5432

Save the file and deploy the concourse with the edited Concourse_Manifest.yaml file.

bosh -d Your_Concourse_Deployment deploy Concourse_Manifest.yaml