On Tue, 2002-10-29 at 17:56, Greg Patnude wrote:
Does anyone know of a reasonable means of synchronizing two (or more)
postgreSQL database servers in order to maintain two COMPLETE concurrent
copies of the same database ?
I'm not sure how complete it is (just starting to look at this myself)
Andrew Sullivan wrote:
On Wed, Oct 30, 2002 at 10:18:47AM -0500, Robert Treat wrote:
regarding replication, as well as a high availability how-to that
would probably be worth reading.
The high availability howto suggests using rsync to synchronise the
data areas of two data servers.
You might want to check out
http://gborg.postgresql.org/genpage?replication_research which has
information and links to several replication solutions for postgresql.
the techdocs.postgresql.org website also has a good number of papers
regarding replication, as well as a high availability how-to
On Wed, Oct 30, 2002 at 10:18:47AM -0500, Robert Treat wrote:
regarding replication, as well as a high availability how-to that
would probably be worth reading.
The high availability howto suggests using rsync to synchronise the
data areas of two data servers. That is an _extremely bad_ idea.