postgresql job from concourse/2.0.2

Github source: 84ac63e 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.

• pid_utils
• postgresql_9.3