Skip to content

postgresql job from concourse/0.69.0

Github source: 5bec8850 or master branch

Properties

blackbox

syslog

sources
postgresql

files whose contents blackbox will emit to its syslog drain

Default
  - /var/vcap/sys/log/postgresql/postgresql.log
  - /var/vcap/sys/log/monit/postgresql_ctl.out.log
  - /var/vcap/sys/log/monit/postgresql_ctl.err.log

consul

agent

services
postgresql

this property auto-registers PostgreSQL as a service

Default
{}

postgresql

databases

a list of databases to create, e.g. [{name:foo}]

listen_host

listening host of the PostgreSQL service

Default
0.0.0.0

listen_port

listening port of the PostgreSQL service

Default
5432

max_connections

maximum number of open database connections

Default
500

roles

a list of roles to create, e.g. [{name:foo,password:bar}]

Templates

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

  • bin/postgresql_ctl (from postgresql_ctl.erb)
  • config/pg_hba.conf (from pg_hba.conf.erb)
  • config/postgresql.conf (from postgresql.conf.erb)

Packages

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