Skip to content

postgresql job from concourse/3.5.0

Github source: 683bd5a 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

checkpoint_segments

Maximum number of log file segments between automatic WAL checkpoints. Increasing this parameter can increase the amount of time needed for crash recovery.

Default
10

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

log_min_duration_statement

Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds. Setting this to zero prints all statement durations. Minus-one (the default) disables logging statement durations.

Default
-1

log_min_messages

Controls which message levels are written to the server log. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, INFO, NOTICE, WARNING, ERROR, LOG, FATAL, and PANIC. Each level includes all the levels that follow it. The later the level, the fewer messages are sent to the log.

Default
LOG

max_connections

Maximum number of open database connections to support.

Default
500

shared_buffers

The amount of memory the database server uses for shared memory buffers. Larger settings for shared_buffers usually require a corresponding increase in checkpoint_segments, in order to spread out the process of writing large quantities of new or changed data over a longer period of time.

Default
1GB

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.