Skip to content

postgres job from postgres/11

The Postgres server provides a single instance Postgres database that can be used with the Cloud Controller or the UAA. It does not provide highly-available configuration.

Github source: bf43ccdf or master branch

Properties

databases

additional_config

A map of additional key/value pairs to include as extra configuration properties

address

The database address

collect_statement_statistics

Enable the pg_stat_statements extension and collect statement execution statistics

Default
false

databases

A list of databases and associated properties to create

db_scheme

The database scheme

log_line_prefix

The postgres printf style string that is output at the beginning of each log line

Default
'%m: '

max_connections

Maximum number of database connections

monit_timeout

Monit timout in seconds for the postgres job start. If not specified, no timeout statement will be added so that the global monit timeout applies.

port

The database port

roles

A list of database roles and associated properties to create

Templates

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

  • bin/pgconfig.sh (from pgconfig.sh.erb)
  • bin/postgres_ctl (from postgres_ctl.erb)
  • bin/postgres_start.sh (from postgres_start.sh.erb)
  • bin/pre-start (from pre-start.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.