Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7DDYWP58377 for ; Mon, 13 Aug 2001 09:34:32 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76I2I679240; Mon, 6 Aug 2001 14:02:18 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f76HvoW90758; Mon, 6 Aug 2001 13:57:50 -0400 (EDT) (envelope-from news) From: Raymond Chui X-Newsgroups: comp.databases.postgresql.general,comp.databases.postgresql.sql Subject: Mirroring the database? Date: Mon, 06 Aug 2001 13:35:01 -0400 Organization: Department of Commerce/NOAA/NWS Lines: 17 Message-ID: <3B6ED545.4C1F96BE@noaa.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200108/163 X-Sequence-Number: 4384 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!