X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2B9A69FBED5 for ; Sat, 26 Aug 2006 03:09:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 99056-01 for ; Sat, 26 Aug 2006 03:08:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60514.mail.yahoo.com (web60514.mail.yahoo.com [209.73.178.177]) by postgresql.org (Postfix) with SMTP id 5F62C9FBEBE for ; Sat, 26 Aug 2006 03:08:19 -0300 (ADT) Received: (qmail 93201 invoked by uid 60001); 26 Aug 2006 06:08:17 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=4NlySFjG/wVTFMGOytxTNxaxKFipvNLHKI/o2FyO0l4zCypDDEWGMRkTXZoTt41jTyKBGx4fNR6yep98rC6/JxsNXwy2AnHM9BteuM8pJG7ecYg/WXcRFFMfTkiyVZ7FsWxFGlDfW9kLdo9f14QTpgVrpWLc/AhninVvKxl4UyI= ; Message-ID: <20060826060817.93199.qmail@web60514.mail.yahoo.com> Received: from [59.95.40.66] by web60514.mail.yahoo.com via HTTP; Fri, 25 Aug 2006 23:08:17 PDT Date: Fri, 25 Aug 2006 23:08:17 -0700 (PDT) From: nilesh khode Reply-To: nilesh khode Subject: DB Synchronization. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-871669014-1156572497=:92944" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.497 tagged_above=0 required=5 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200608/301 X-Sequence-Number: 22844 --0-871669014-1156572497=:92944 Content-Type: text/plain; charset=us-ascii Hello All, I am having Postgresql 8 installed on 2 RH Linux box. I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server. I am having one question about the synchronization. How to keep another server in updated mode? It should takes an updated db from first server and restore it on another server. Please help me out. Regards, Nilesh --0-871669014-1156572497=:92944 Content-Type: text/html; charset=us-ascii

Hello All,

I am having Postgresql 8 installed on 2 RH Linux box.
I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server.

I am having one question about the synchronization.
How to keep another server in updated mode?
It should takes an updated db from first server and restore it on another server.

Please help me out.

Regards,
Nilesh

--0-871669014-1156572497=:92944--