???s with appropriate values.
Following example does not account for release job
collocation or for optional/conflicting properties.
IP address on which the PostgresSQL server will listen.
Port on which the PostgresSQL server will listen.
Maximum number of log file segments between automatic WAL checkpoints. Increasing this parameter can increase the amount of time needed for crash recovery.
List of databases to create, along with a role name and password of a role to create for the database.
- 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
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.
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.
Maximum number of open database connections to support.
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.
Templates are rendered and placed onto corresponding
instances during the deployment process. This job's templates
will be placed into
- bin/postgresql_ctl (postgresql_ctl.erb)
- config/pg_hba.conf (pg_hba.conf.erb)
- config/postgresql.conf (postgresql.conf.erb)