Database syncronization - Mailing list pgsql-general

From Lowell.Hought@faa.gov
Subject Database syncronization
Date
Msg-id OF456EA4D5.75E9251B-ON86257058.004F7D86-86257058.004FA96A@faa.gov
Whole thread Raw
Responses Re: Database syncronization  (Richard Huxton <dev@archonet.com>)
List pgsql-general

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?

pgsql-general by date:

Previous
From: postgresql@bryden.co.za
Date:
Subject: Cross database queries
Next
From: Michael Fuhr
Date:
Subject: Re: Query stucked in pg_stat_activity