X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C2D2F52806 for ; Tue, 19 Jul 2005 05:07:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59991-07 for ; Tue, 19 Jul 2005 08:07:31 +0000 (GMT) Received: from lucius.provo.novell.com (lucius.provo.novell.com [137.65.81.172]) by svr1.postgresql.org (Postfix) with ESMTP id 43398529D7 for ; Tue, 19 Jul 2005 05:07:29 -0300 (ADT) Received: from INET-PRV1-MTA by lucius.provo.novell.com with Novell_GroupWise; Tue, 19 Jul 2005 02:07:31 -0600 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.4 Beta Date: Tue, 19 Jul 2005 07:32:06 -0600 From: "Shashi Kanth Boddula" To: Subject: Mirroring problem with PostgreSQL Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part3112A3C6.0__=" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.554 tagged_above=0 required=5 tests=AWL, DATE_IN_FUTURE_03_06, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_FONT_BIG, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200507/125 X-Sequence-Number: 18181 This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__Part3112A3C6.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi, One of my client is facing one issue the with PostgreSQL . The details are as follows . 1 . PostgreSQL version 7.4.8 is running on 2 Linux machine . One acting as a primary database server and another one is acting as a fail-over (secondary)server . 2. Primar & secondary servers are located at different locations 2. Using DBmirror utility to mirror the database from primary to secondary . With above setup , the problem is , there is a 1 day delay between primary and secondary in the synchronization . That menas , if a client put a record in the primary , it will sync to the secondary with delay of 24 hours . My question is , for above mentioned requirement , what is the currect way to solve the problem . I would like to know Is there any other way to solve this problem . My idea is to implement DRBD to mirror the database between primary and secondary . But , i want to know can DRBD suite this requirement or not . And , is there any limitation while using DRBD in a WAN environment . Thanks & Regards, Shashi Kanth --=__Part3112A3C6.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable =20
Hi,
 
One of my client is facing one issue the with PostgreSQL . = The details are as follows .
 
1 . PostgreSQL  version 7.4.8 is running on 2 = Linux machine  . One acting as a primary database server and = another one is acting as a fail-over (secondary)server .
2. Primar & secondary servers are located at different = locations
2.  Using DBmirror utility to mirror the database = from primary to secondary .
 
With above setup , the problem is , there is a 1 day delay = between primary and secondary in the synchronization . That menas , if a = client put a record in the primary , it will sync to the secondary with = delay of 24 hours .
 
My question is , for above mentioned requirement , what is = the currect way to solve the problem . I would like to know Is there any = other way to solve this problem .
 
My idea is to implement DRBD to mirror the database between = primary and secondary . But , i want to know can DRBD suite this requiremen= t or not . And , is there any limitation while using DRBD in a WAN = environment .
 
 Thanks & Regards,
Shashi Kanth
--=__Part3112A3C6.0__=--