Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 00D799FBAAD;
	Thu, 12 Apr 2007 21:39:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 74944-03; Thu, 12 Apr 2007 21:39:15 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from bay0-omc3-s15.bay0.hotmail.com (bay0-omc3-s15.bay0.hotmail.com
	[65.54.246.215])
	by postgresql.org (Postfix) with ESMTP id 3980E9FBACA;
	Thu, 12 Apr 2007 21:39:15 -0300 (ADT)
Received: from BAY131-W5 ([65.55.136.40]) by bay0-omc3-s15.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.2668);
	Thu, 12 Apr 2007 17:39:13 -0700
Message-ID: <BAY131-W51B848DDB3A1D7B5191DAB05D0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_1c085a21-3dfb-4118-af74-c84d7c1f5a66_"
X-Originating-IP: [67.116.31.14]
From: Karthikeyan Sundaram <skarthi98@hotmail.com>
To: <pgsql-admin@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: setting up a mirroring or replication database
Date: Thu, 12 Apr 2007 17:39:13 -0700
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 13 Apr 2007 00:39:13.0503 (UTC)
	FILETIME=[289E8EF0:01C77D64]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.383 tagged_above=0 required=5 tests=AWL=-1.621,
	BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708,
	HTML_30_40=0.374, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72
X-Spam-Level: *
X-Archive-Number: 200704/126
X-Sequence-Number: 25190

--_1c085a21-3dfb-4118-af74-c84d7c1f5a66_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi Team,
=20
    We are using Postgres 8.1.0 and in the plans to migrate to 8.2.3.   Our=
s is a OLTP application.  Publishers, advertisers and consumers use our sys=
tem world wide.  Right now it's not a very big database. But we are expandi=
ng our operations to Europe and US where we are expecting a moster growth.
=20
    I want to setup a mirroring database or replications database so that i=
f one database crash, the load balancing database should take care or it.  =
Not only that, if I am upgrading one database, the other should take the lo=
ad.=20
=20
    I have never set this kind of replication or mirroring the database bef=
ore.  What are the steps and procedures to do this kind of setup.
=20
   Please advise.
=20
Regards
skarthi
=20
_________________________________________________________________
Live Search Maps =96 find all the local information you need, right when yo=
u need it.
http://maps.live.com/?icid=3Dwlmtag2&FORM=3DMGAC01=

--_1c085a21-3dfb-4118-af74-c84d7c1f5a66_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
Hi Team,<BR>
&nbsp;<BR>
&nbsp;&nbsp;&nbsp; We are using Postgres 8.1.0 and in the plans to migrate =
to 8.2.3.&nbsp;&nbsp; Ours is a OLTP application.&nbsp; Publishers, adverti=
sers and consumers use our system world wide.&nbsp; Right now it's not a ve=
ry big database. But we are expanding our operations to Europe and US where=
 we are&nbsp;expecting a&nbsp;moster growth.<BR>
&nbsp;<BR>
&nbsp;&nbsp;&nbsp; I want to setup a mirroring database or replications dat=
abase so that if one database crash, the load balancing database should tak=
e care or it.&nbsp; Not only that, if I am upgrading one database, the othe=
r should take the load. <BR>
&nbsp;<BR>
&nbsp;&nbsp;&nbsp; I have never set this kind of replication or mirroring t=
he database before.&nbsp; What are the steps and procedures to do this kind=
 of setup.<BR>
&nbsp;<BR>
&nbsp;&nbsp; Please advise.<BR>
&nbsp;<BR>
Regards<BR>
skarthi<BR>
<BR>&nbsp;<BR><br /><hr />Live Search Maps =96 find all the local informati=
on you need, right when you need it. <a href=3D'http://maps.live.com/?icid=
=3Dwlmtag2&FORM=3DMGAC01' target=3D'_new'>Find it!</a></body>
</html>=

--_1c085a21-3dfb-4118-af74-c84d7c1f5a66_--