Received: from web9608.mail.yahoo.com (web9608.mail.yahoo.com [216.136.129.187]) by hub.org (8.10.1/8.10.1) with SMTP id e911e2p91341 for ; Sat, 30 Sep 2000 21:40:02 -0400 (EDT) Message-ID: <20001001013956.52750.qmail@web9608.mail.yahoo.com> Received: from [203.199.220.72] by web9608.mail.yahoo.com; Sat, 30 Sep 2000 18:39:56 PDT Date: Sat, 30 Sep 2000 18:39:56 -0700 (PDT) From: Dronamraju Rajesh Subject: how can I mirror a postgres database To: pgsql-admin@postgreSQL.org, pgsql-sql@postgreSQL.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200009/81 Hi all, I am having postgres6.5 installed on a remote linux server. Now i have installed the same scenario in a local machine. Now i want to update my local machine with any transaction or changes made in remote machine. something like a oracle parallel server. where if one machine breaks down due to some reason the other machine can take over as it has all the data with it. I want to move my complete database with critical data on to postgres. can anybody please suggest how do i do it as the server is a mission critical server. any suggestions are appreciated and thanks for all of the suggestions in advance. Thanks & Regards Rajesh. __________________________________________________ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/