postgres v3.2.2

Software Updates

• Upgrade PostgreSQL to 9.5.25 (ca February 11, 2021)
• Upgrade HAProxy to 1.8.30
• Upgrade PCRE to 10.39
• Upgrade socat to 1.7.3.4

Deployment

releases:
- name:    postgres
  version: 3.2.2
  url:     https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.2.2/postgres-3.2.2.tgz
  sha1:    7699715ed0b7ec129f60958e2864958030333cea

postgres v3.2.1

Software Updates

• Upgrade PostgreSQL to 9.5.21 (released 2020-02-13)
• Upgrade HAProxy to 1.8.23
• Upgrade PCRE to 10.33

Deployment

releases:
- name:    postgres
  version: 3.2.1
  url:     https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.2.1/postgres-3.2.1.tgz
  sha1:    b687753085f770807603642b4bae6c17a483900b

postgres v3.2.0

Software Updates

• Upgrade PostgreSQL to 9.5.19 (ca August 5th, 2019)

Bug Fixes

• Fix an issue in the hba.conf that occurs when BOSH links are by
  DNS (and do not export the IPs of the other VMs).

Deployment

releases:
- name:    postgres
  version: 3.2.0
  url:     https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.2.0/postgres-3.2.0.tgz
  sha1:    470c2b6d98d988ad9dc36dedcd8133e247de63f7

v3.1.5

Improvements

• Disabled archival of WAL, instead using /bin/true
• Bumped WAL segment retention to 128 segments
• Changed logging format for PostgreSQL logs

Deployment

releases:
- name: postgres
  version: 3.1.5
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.5/postgres-3.1.5.tgz
  sha1: 30feaf3522b205812f3d363380dee57d20e5e32a

v3.1.4

Improvements

• Added postgres.replication.psql_error_count configuration value
  which allows an operator to define how many failed health checks
  occur before failover.

Deployment

releases:
- name: postgres
  version: 3.1.4
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.4/postgres-3.1.4.tgz
  sha1: 3c5b80b6c09d191783634be269896c86fc8e3d7c

v3.1.3

Improvements

• Postgres deployed as HA will now shutdown in cases of split-brain.
• Added a script to help recover Postgres VMs after a failure mode.

If the two nodes notice both are master (which can occur in certain
cases, see README.md for more information), we have opted to have
both VMs shut down their Postgres processes in the interest of
data integrity. To assist in this process, we have added a script
to start the processes again. Please see README.md for more
information on this process.

Deployment

releases:
- name: postgres
  version: 3.1.3
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.3/postgres-3.1.3.tgz
  sha1: 10e220745a3cad35754cb4f6da8fd3cce8ed4919

v3.1.2

Improvements

In this release we've fixed a bug where keepalived was disabled, no matter the
setting. The intended logic of "keepalived is enabled by default, disabled via
keepalived.enabled: false" holds.

Deployment

releases:
- name: postgres
  version: 3.1.2
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.2/postgres-3.1.2.tgz
  sha1: 64d9ba90390336b9721f9fc485c0ff1e396b29c7

v3.1.1

Improvements

Increase monit start timeout of the Postgres job to 60 seconds (previously 30
seconds). This fixes a bug where the Postgres job would be prematurely killed by
monit during boot.

Deployment

releases:
- name: postgres
  version: 3.1.1
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.1/postgres-3.1.1.tgz
  sha1: 793b8c9a4a39a01b5be97804a76424679aafe120

v3.1.0

Improvements

• Default timeouts for HAProxy have been bumped from 30 seconds to
  five whole minutes (a 10x increase!) This should help take care
  of people running the psql client interactively, and not issuing
  a command at least twice a minute.

• Keepalived (+VRRP) is now optional. If you set the new property
  keepalived.enabled to false, you still get HA, but the VIP
  doesn't matter because keepaliveditself won't be running.

  You can still hook up the haproxy instances to an IaaS load
  balancer, like an AWS ELB.

• Logging is way better, with at least 50% less noise!

Deployment

releases:
- name: postgres
  version: 3.1.0
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.1.0/postgres-3.1.0.tgz
  sha1: f90314b150279cfcf61b4e6842cbe29f1003898c

v3.0.0

New Features

• Added option to deploy Postgres as a two-node HA cluster with HAProxy and a
  VRRP VIP. It features auto-failover and auto-recovery. Uses streaming
  replication via WAL.

More information about HA postgres can be found in the README, and an example
manifest has been provided under manifests/ha.yml

Deployment

releases:
- name: postgres
  version: 3.0.0
  url: https://github.com/cloudfoundry-community/postgres-boshrelease/releases/download/v3.0.0/postgres-3.0.0.tgz
  sha1: a5070c285d44b3ac0fb678b1ae640461668b87c5