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 E8D919FC10F for ; Sat, 26 Aug 2006 12:15:05 -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 28222-05 for ; Sat, 26 Aug 2006 12:15:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id E31EF9FC0FF for ; Sat, 26 Aug 2006 12:15:01 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so1689044pyd for ; Sat, 26 Aug 2006 08:15:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HADg0hpJszGjPrnMuiTgdF9kE395IRxnc5FtAFB0CHfeHga0p9INiNrK2f4JXWBz2O8qTDRGlBjHjaGVbsHNoVCqf6RVAGLbndWv8MIHpGBzvc2jlIgDQupxP79UDfeUYimX/NTLgGSlU5C3rvV7E5YFz71vpqDGosNX/LBk18A= Received: by 10.35.41.12 with SMTP id t12mr7677994pyj; Sat, 26 Aug 2006 08:15:01 -0700 (PDT) Received: by 10.35.125.13 with HTTP; Sat, 26 Aug 2006 08:15:00 -0700 (PDT) Message-ID: Date: Sat, 26 Aug 2006 20:15:00 +0500 From: "Shoaib Mir" To: "nilesh khode" Subject: Re: DB Synchronization. Cc: pgsql-admin@postgresql.org In-Reply-To: <20060826060817.93199.qmail@web60514.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_220088_13001284.1156605300964" References: <20060826060817.93199.qmail@web60514.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.621 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/303 X-Sequence-Number: 22846 ------=_Part_220088_13001284.1156605300964 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline You can use Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php) for replication (data synchronization) and it also does offer the failover (not automatic) feature as well. You can also have a combination of Linux HA + Slony for high availablity. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 8/26/06, nilesh khode wrote: > > 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 > ------=_Part_220088_13001284.1156605300964 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline You can use Slony (http://gborg.postgresql.org/project/slony1/projdisplay.php) for replication (data synchronization) and it also does offer the failover (not automatic) feature as well.

You can also have a combination of Linux HA + Slony for high availablity.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 8/26/06, nilesh khode <nilesh_khode@yahoo.com> wrote:

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





------=_Part_220088_13001284.1156605300964--