Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --
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) but 'dbbalancer' at least makes some claims to this. It acts as (basically) a postgresql proxy server, and can send queries to multiple servers. My presumption would be that if you initialize 2 databases to a known identical start, have all the same triggers and rules on both, then send all queries to both databases, you will have 2 identical databases at the end. Don't know how well that will work in practice tho. I should know more in the next couple of weeks. b.g. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --
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. I've suggested before that the link be removed, because it recommends something almost guaranteed to introduce massive database corruption at some point. If there's no load and you have a fast network, you might get lucky. But it is an extremely dangerous plan. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] Database replication... - Mission Critical DBMS's --
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" that would probably be worth reading. Robert Treat On Wed, 2002-10-30 at 09:24, Bill Gribble wrote: > 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) > but 'dbbalancer' at least makes some claims to this. It acts as > (basically) a postgresql proxy server, and can send queries to multiple > servers. My presumption would be that if you initialize 2 databases to > a known identical start, have all the same triggers and rules on both, > then send all queries to both databases, you will have 2 identical > databases at the end. > > Don't know how well that will work in practice tho. I should know more > in the next couple of weeks. > > b.g. > > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
