X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2D10F52B68
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 25 Jul 2005 09:37:08 -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 63237-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 25 Jul 2005 12:36:59 +0000 (GMT)
Received: from lucius.provo.novell.com (lucius.provo.novell.com
	[137.65.81.172])
	by svr1.postgresql.org (Postfix) with ESMTP id 9F9E552AEE
	for <pgsql-performance@postgresql.org>;
	Mon, 25 Jul 2005 09:36:57 -0300 (ADT)
Received: from INET-PRV1-MTA by lucius.provo.novell.com
	with Novell_GroupWise; Mon, 25 Jul 2005 06:37:00 -0600
Message-Id: <s2e4888c.065@lucius.provo.novell.com>
X-Mailer: Novell GroupWise Internet Agent 6.5.4 Beta
Date: Mon, 25 Jul 2005 12:01:52 -0600
From: "Shashi Kanth Boddula" <sboddula@novell.com>
To: <pgsql-performance@postgresql.org>
Subject: Mirroring PostgreSQL database
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__PartE6C54C00.0__="
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.622 tagged_above=0 required=5 tests=AWL,
	DATE_IN_FUTURE_03_06, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_FONT_BIG,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200507/367
X-Sequence-Number: 13608

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.

--=__PartE6C54C00.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi, 
I have one customer who is using PostgreSQL 7.4.8 on Linux . He has some
problems with database mirroring . The details are follows. 
The customer is using Linux on which PostgreSQL 7.4.8 along with Jboss
3.2.3 is running . He has 2 servers , one is acting as a live server
(primary) and another is acting as a fail-over (secondary)  server . 
Secondary server is placed in remote location . These servers are acting
as a Attendence server for daily activities . Nearly 50,000 employees
depend on the live server . 
  
The customer is using DBmirror tool to mirror the database records of
primary to secondary . The customer is complaining that there is one day
(24 hours) delay between primary and secondray for database
synchronization . They have dedicated line and bandwidth , but still the
problems exists. 
  
I just want to know , for immediate data mirroring , what is the best
way for PostgreSQL . PostgreSQL is offering many mirror tools , but
which one is the best ?. Is there any other way to accomplish the task ?

  
Thank you . Waiting for your reply. 
  

Thanks & Regards,
Shashi Kanth
Consultant - Linux
RHCE , LPIC-2
Onward Novell - Bangalore
9886455567




--=__PartE6C54C00.0__=
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <style type=3D"text/css">
      <!--
        body { margin-left: 4px; font-variant: normal; margin-bottom: 1px; =
margin-right: 4px; line-height: normal; margin-top: 4px }
      -->
    </style>
   =20
  </head>
  <body>
    <DIV>
      <font size=3D"4">Hi,
</font>    </DIV>
    <DIV>
      <font face=3D"Dialog" size=3D"4">
</font>    </DIV>
    <DIV>
      <font face=3D"Dialog" size=3D"4">I have one customer who is using =
PostgreSQL 7.4.8 on Linux . He has some problems with database mirroring . =
The details are follows.
</font>    </DIV>
    <DIV>
      <font size=3D"4">
</font>    </DIV>
    <div>
    <DIV>      The customer is using Linux on which PostgreSQL 7.4.8 along =
with Jboss 3.2.3 is running . He has 2 servers , one is acting as a live =
server (primary) and another is acting as a fail-over (secondary)&nbsp;&#16=
0;server .&nbsp;&#160;Secondary server is placed in remote location . =
These servers are acting as a Attendence server for daily activities . =
Nearly 50,000 employees depend on the live server .
    </div>
    <div>
    <DIV>      &#160;
    </div>
    <div>
    <DIV>      The customer is using DBmirror tool to mirror the database =
records of primary to secondary . The customer is complaining that there =
is one day (24 hours) delay between primary and secondray for database =
synchronization . They have dedicated line and bandwidth , but still the =
problems exists.
    </div>
    <div>
    <DIV>      &#160;
    </div>
    <div>
    <DIV>      I just want to know , for immediate data mirroring , what =
is the best way for PostgreSQL . PostgreSQL is offering many mirror tools =
, but which one is the best ?. Is there any other way to accomplish the =
task ?
    </div>
    <div>
    <DIV>      &#160;
    </div>
    <div>
    <DIV>      Thank you . Waiting for your reply.
    </div>
    <div>
    <DIV>      &#160;
    </div>
  <br>Thanks & Regards,<br>Shashi Kanth<br>Consultant - Linux<br>RHCE , =
LPIC-2<br>Onward Novell - Bangalore<br>9886455567<br><br><br></body>
</html>

--=__PartE6C54C00.0__=--