Lowell.Hought@faa.gov wrote:
> What is the most effective method for syncronizing a database from a main
> to a backup machine? I am now running 8.0. Is it necessary to drop the
> database from the secondary machine and restore it from a dump of the
> primary?
Depends on how often/up-to-date you want to be. In order of delay, they are:
1. pg_dump / pg_restore
2. PITR + WAL-file shipping
3. Replication (e.g. Slony)
Check the manuals for the first two. There are other replication
projects available if Slony isn't quite right for you.
--
Richard Huxton
Archonet Ltd