Hypatia PostgreSQL Backups

Backups are currently performed with cron and a replicated copy taken offsite.

  • replication to drinfdb: asynchronous but effectively immediate
  • hourly for a day
  • daily for a week
  • weekly for a year
    0 1-23 * * * /usr/bin/om postgresql backup -q $(date "+Hourly-\%H00") 2>&1 | egrep -v '^\[OK\]'
    50 23 * * 1-6 /usr/bin/om postgresql backup -q $(date "+Daily-\%a") 2>&1 | egrep -v '^\[OK\]'
    50 23 * * sun /usr/bin/om postgresql backup -q $(date "+Weekly-\%W") 2>&1 | egrep -v '^\[OK\]'

Backups are placed in /disk/backup, which is mirrored daily. As gzipped sql scripts, this will use just over 1/10th of our backup partition, so more comprehensive retention is an option.

The postgresql component is due for improvement: as part of this checks will be performed to ensure that backup was successful. For now, a nightly restore is placed onto a test server to ensure consistency.

For restoration details see HypatiaPostgresRestoration.

-- TimColles - 27 Nov 2018

Topic revision: r1 - 27 Nov 2018 - 13:51:39 - TimColles
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies