Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76K2J612823; Mon, 6 Aug 2001 16:02:19 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f76Jw4Z92067; Mon, 6 Aug 2001 15:58:04 -0400 (EDT) (envelope-from news) From: Allan Engelhardt X-Newsgroups: comp.databases.postgresql.general,comp.databases.postgresql.sql Subject: Re: Mirroring the database? Date: Mon, 06 Aug 2001 20:57:55 +0100 Organization: http://cybaea.com/ Message-ID: <3B6EF6C3.F3897443@cybaea.com> References: <3B6ED545.4C1F96BE@noaa.gov> X-NNTP-Posting-Host: engelhardt.demon.co.uk:193.237.12.86 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.7 i686) X-Accept-Language: en MIME-Version: 1.0 To: Raymond Chui Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 33 To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200108/108 X-Sequence-Number: 13328 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!