Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --

2002-11-04 Thread Bill Gribble
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)

Re: [HACKERS] [GENERAL] Database replication... - Mission Critical

2002-11-01 Thread Justin Clift
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.

Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --

2002-10-30 Thread Robert Treat
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

Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --

2002-10-30 Thread Andrew Sullivan
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.