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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly