Skip to content

postgresql job from concourse/2.7.0

Github source: 2fed931 or master branch

Properties

bind_ip

IP address on which the PostgresSQL server will listen.

Default
0.0.0.0

bind_port

Port on which the PostgresSQL server will listen.

Default
5432

databases

List of databases to create, along with a role name and password of a role to create for the database.

Example
- name: my-database
  password: my-db-password
  role: my-db-role
- name: my-other-database
  password: my-other-db-password
  role: my-other-db-role

max_connections

Maximum number of open database connections to support.

Default
500

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.