Re: Backup, was RE: [SL] While installing on SME etc, etc

[Mark B. <ma...@ga...>]

On Wed, May 03, 2006 at 11:34:39AM +1000, david wrote:

> What would you do if you were > depending on live data being entered
> from lots of locations and the loss of an hour's entries could be
> catastrophic?

Software raid 1 on all servers, pgdump + dump(8) for backups, and db
replication (but only write to one db to keep things simple). Pipe dump
output through gzip and store a couple months worth (or whatever) on a
NAS.

Dump is the fastest I have found for backups and restores. Speed of
restore is very important and something people forget about.

This is why people pay for good hosting companies.  :)

m