From PostgreSQL wiki
Jump to navigationJump to search

Backups are important. People turn up on the mailing list frequently with problems that could've been avoided or solved much more easily with proper backups.

See the manual for plenty of information on backing up PostgreSQL.

It's highly recommended that you keep both pg_dump backups and pg_basebackup. They can protect you against damage caused by undetected disk or file system corruption, severe admin errors, PostgreSQL bugs (gasp!), etc.

If up-to-date backups or warm standby are important, continuous archiving backups.They can make sure that you have backups up to the moment of a failure in most cases, rather than having to go back to last night's tapes.

Several open source software exist to manage backups, if possible avoid (re)writing your own and avoid «home made» scripts.

Backups without proper recovery testing are not backups!