From sboddula@novell.com Tue Jul 19 08:07:40 2005 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__=-- From peter_e@gmx.net Tue Jul 19 20:33:26 2005 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 27DD952A0C for ; Tue, 19 Jul 2005 17:33:26 -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 56432-06 for ; Tue, 19 Jul 2005 20:33:24 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 4821252AAE for ; Tue, 19 Jul 2005 17:33:21 -0300 (ADT) Received: (qmail invoked by alias); 19 Jul 2005 20:33:23 -0000 Received: from dsl-082-083-226-091.arcor-ip.net (EHLO colt.pezone.net) [82.83.226.91] by mail.gmx.net (mp025) with SMTP; 19 Jul 2005 22:33:23 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: "Shashi Kanth Boddula" Subject: Re: Mirroring problem with PostgreSQL Date: Tue, 19 Jul 2005 22:33:23 +0200 User-Agent: KMail/1.8.1 Cc: pgsql-admin@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200507192233.24003.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/136 X-Sequence-Number: 18192 Shashi Kanth Boddula wrote: > My idea is to implement DRBD to mirror the database between primary > and secondary . But , i want to know can DRBD suite this requirement Sure. This is a fairly common setup. > And , is there any limitation while using DRBD in a WAN > environment . Sure. It will be slow. But you should test yourself just how slow it will be. -- Peter Eisentraut http://developer.postgresql.org/~petere/