Skip to content

postgres job from gogs/5.5.1

The Postgres server provides a single instance Postgres database that can be used with the Cloud Controller or the UAA. It does not provide highly-available configuration.

Github source: e4b38db or master branch

Properties

databases

address

The database address

Default
127.0.0.1

databases

A list of databases and associated properties to create

Default
[]
Example
databases: |+
  - name: gogs
    citext: true
    tag: gogs

db_scheme

The database scheme

Default
postgres

log_line_prefix

The postgres printf style string that is output at the beginning of each log line

Default
'%m: '

max_connections

Maximum number of database connections

Default
500

port

The database port

Default
5432

roles

A list of database roles and associated properties to create

Default
[]
Example
roles: |+
  - name: gogs
    password: MyGogsPassword
    tag: gogs

Templates

Templates are rendered and placed onto corresponding instances during the deployment process. This job's templates will be placed into /var/vcap/jobs/postgres/ directory (learn more).

  • bin/postgres_ctl (from postgres_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.