This document covers the backup and restore procedures for the machines involved in the RAT PostgreSQL service. Replace 'pgteach' with the appropriate alias in the instructions below.
|burly||(pgteach)||teaching postgresql server|
|cracker||(pgresearch)||research postgresql server|
Backup is performed nightly, and consists of the following stages:
/disk/dbdata/rsyncdirectory on pgteach. This is currently mirrored to:
The following should be all that is required to return the whole of service to working order, if a database server become inoperable:
pgXXXXX's lcfg profile to the new machine.
pgteachpoints to the new machine.
/disk/dbdata/rsyncdirectory from mirror or tape backup.
$ cat nightly.sql.gz | gunzip | psql
$ pgluser --dry-run --verbose [--prune]and, if the results look sane, re-enable pgluser:
$ om cron configure
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh