Project

General

Profile

Actions

Task #901

open

schedule regular pg_dump backups of the DB

Added by Aaron Marcuse-Kubitza about 10 years ago. Updated about 10 years ago.

Status:
New
Priority:
Normal
Start date:
04/17/2014
Due date:
% Done:

70%

Estimated time:
Activity type:

Description

  • this is not backed up with the rest of the VM due to bandwidth limitations and available tape drive space
  • use --jobs (which requires --format=directory) to speed up the backup by using multiple cores
  • also dump other vegbiendev DBs (eg. geoscrub)
  • run pg_dumpall --globals-only as well to back up user accounts
  • note that recovery with this method requires initdb before restoring
Actions

Also available in: Atom PDF