postgresql job from concourse/3.3.2
Github source:
48c773d
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
(frompostgresql_ctl.erb
)config/pg_hba.conf
(frompg_hba.conf.erb
)config/postgresql.conf
(frompostgresql.conf.erb
)
Packages¶
Packages are compiled and placed onto corresponding
instances during the deployment process. Packages will be
placed into /var/vcap/packages/
directory.