Re: Need Help in Taking Backups

Well, you can take a pg_dump to get the state of the system at a point
in time.  That's very easy.

But you really need to specify your 'disaster modelling' and recovery
requirements in _much_ greater detail.  It may be that in order to
keep recovery time down, you'll need to use a replication system such
as Slony-I to give you a "hot backup" that's sitting just a few
transactions behind.
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxfinances.info/info/postgresql.html
"We defeated the enemy with teamwork and the hammer of not bickering."
-- The Shoveller, Mystery Men