v2.0.0

• CI pipeline is testing + creating final releases using bosh2; also includes testflight-pr to automatically test pull requests
• WIP manifests/postgres.yml to deploy a cluster of pgpool/postgres. smoke-tests errand is disabled in CI at the time of this release being cut.
• postgres job's db link exposes postgres.config, pgpool.users, and pgpool.databases

Deployment

releases:
- name: postgres
  version: 2.0.0
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v2.0.0/postgres-2.0.0.tgz
  sha1: dea5cad517c62afaf97a1b31df41ad691928d960

PostgreSQL BOSH Release v1.1.0

Bug Fixes

• Fixed a bug in the template for pgpool that was redirecting all
  traffic to the local postgres node, causing a less-than-HA
  situation. This is a pretty serious deficiency, so anyone using
  this release should upgrade.

PostgreSQL BOSH Release v1.0.4

Upgrades

• pgpoolII upgraded from 3.5.0 to 3.5.4

Improvements

• All UNIX domain sockets now reside under /var/vcap/sys/run,
  where they ought to, and not in /tmp.
• Admin accounts can now be created via the admin property
  on entries in pgpool.users.

Manifest

releases:
- name: postgres
  version: 1.0.4
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v1.0.4/postgres-1.0.4.tgz
  sha1: 8b82c86b7763abdb8f117523b852d1e1c9a20eeb

PostgreSQL BOSH Release v1.0.3

Improvements

• When custom databases are created, the manifest can be used to
  specify any PG extensions that need to be loaded via the extensions
  array attribute on the database.
  Example:

properties:
  pgpool:
    databases:
    - name: animals
      extensions:
      - citext
      - pgcrypto

Manifest

releases:
- name: postgres
  version: 1.0.3
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v1.0.3/postgres-1.0.3.tgz
  sha1: f3f0282266b492a3e72a94c745caec1a6a41bf46

PostgreSQL BOSH Release v1.0.2

New Features

• Added the pgpool.databases property to auto create databases in postgres
  Example:

    pgpool:  
      databases:
      - name: animals
        users:
        - porcupine
        - hedgehog

PostgreSQL BOSH Release v1.0.0

Initial Release

Supports replicated pgpool / postgres configurations, as well as
standalone single-node postgres deployments.