Received: from mta05.mail.mel.aone.net.au (mta05.mail.au.uu.net [203.2.192.85]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f791qV617427; Wed, 8 Aug 2001 21:52:31 -0400 (EDT) (envelope-from justin@postgresql.org) Received: from postgresql.org ([63.34.210.187]) by mta05.mail.mel.aone.net.au with ESMTP id <20010809015226.QSZM14656.mta05.mail.mel.aone.net.au@postgresql.org>; Thu, 9 Aug 2001 11:52:26 +1000 Message-ID: <3B71ECAF.65EBD3A0@postgresql.org> Date: Thu, 09 Aug 2001 11:51:43 +1000 From: Justin Clift X-Mailer: Mozilla 4.77 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Allan Engelhardt CC: Raymond Chui , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Re: Mirroring the database? References: <3B6ED545.4C1F96BE@noaa.gov> <3B6EF6C3.F3897443@cybaea.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/199 X-Sequence-Number: 13429 There's also PostgreSQL Replicator (which I haven't gotten around to trying) : http://pgreplicator.sourceforge.net :-) Regards and best wishes, Justin Clift Allan Engelhardt wrote: > > Ehhh, use dual-ported RAID disks? (Well, tri-port in your case, but maybe A and B machines are enough. You still have a (small) single point of failure, but you probably have that anyhow (network switch?). You'll need some way of brining PostgreSQL up on B when A dies, but that could be a simple script. Reconnect would of course be manual from the point of the client.). > > Or buy Oracle. > > Replication is at the top of the TODO list: http://www.uk.postgresql.org/docs/todo.html > > Allan. > > PS: > Maybe SQLB does some of what you want? http://sourceforge.net/projects/sqlb/ [The documentation is a little opaque...I'm not quite sure what it does, exactly. Anybody want to comment?] > > Raymond Chui wrote: > > > Does the latest PostgreSQL 7.1.2 support database mirroring? > > > > I have machine A, B and C, they all have the same database and tables. > > Machine A is the operational machine, machine B and C are backup. > > > > If users do INSERT, UPDATE and DELETE in machine A, I want have the > > same SQL statements in machine B and C. > > > > 1. I can do pg_dump or COPY every hour. > > 2. I can use PerlDBI or JDBC open multiple connections for each SQL > > statement. > > 3. But I prefer if the system auto mirroring the database, then I can do > > nothing. > > All I need is set the auto mirroring configure. > > > > Please tell me how to do in 3. above. Thank you in advance! > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi