Lowell.Hought@xxxxxxx 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
