Skip to content

bbr-postgres-db job from postgres/52

This sample job must be collocated with the postgres job since leverages local db connections.

Github source: 5e330a7 or master branch

Properties

postgres

client_certificate

Client certificate. Specify it if you want to auhtenticate using certificates.

Default
""

client_certificate_key

Secret key used for the client certificate. Specify it if you want to auhtenticate using certificates.

Default
""

databases

Databases to backup and restore (not used when using links)

Default
[]

dbuser

Database user to run backup and restore

Default
vcap

port

The database port (not used when using links)

Default
5432

single-transaction

uses singele transaction when restoring databases

Default
false

ssl_verify_hostname

If postgres is configured with a ca, setting this to ‘true’ changes sslmode to ‘verify-full’ rather than ‘verify-ca’.

Default
true

version

The database version e.g. 11, 13, 15 or 16

Default
16

release_level_backup

Include postgres in backup and restore operations

Default
false

Templates

Templates are rendered and placed onto corresponding instances during the deployment process. This job's templates will be placed into /var/vcap/jobs/bbr-postgres-db/ directory (learn more).

  • bin/bbr/backup (from backup.sh.erb)
  • bin/bbr/restore (from restore.sh.erb)
  • config/ca_cert (from ca_cert.erb)
  • config/client_certificate (from client_certificate.erb)
  • config/client_certificate_key (from client_certificate_key.erb)
  • config/config.sh (from config.sh.erb)
  • config/pgpass (from pgpass.erb)

Packages

Packages are compiled and placed onto corresponding instances during the deployment process. Packages will be placed into /var/vcap/packages/ directory.