Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 8BE101337B6D
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue,  2 Nov 2010 11:23:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 94334-02
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue,  2 Nov 2010 14:23:17 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from abpni.co.uk (unknown [92.27.106.173])
	by mail.postgresql.org (Postfix) with ESMTP id A09DF1337B69
	for <pgsql-general@postgresql.org>;
	Tue,  2 Nov 2010 11:23:14 -0300 (ADT)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CB7A99.7C0FD228"
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: Re: Replication
Date: Tue, 2 Nov 2010 14:20:54 -0000
Message-ID: <46C13AA90DB8844DAB79680243857F0F0AFF07@server1.ABPNI.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [GENERAL] Replication
Thread-Index: Act6kUOWR3pDQKXYRkmpq9v+PbWALQAB+VfN
References: 
 <4CCF1AC4.6060800@abpni.co.uk><AANLkTin8x5EruxEser40veOzq8_kGWbaQ7VkPy0H=hXM@mail.gmail.com><4CCF4187.8010205@abpni.co.uk><AANLkTingS59Fep3u-JoDw77oauoqu2inBffPCuCNxxdr@mail.gmail.com><4CCFB6CF.4060006@abpni.co.uk>
	<AANLkTikZ-H3mHMAQ2wy-tnKcbYcTLAUn5xjAJeM4Wj7D@mail.gmail.com>
From: "Jonathan Tripathy" <jonnyt@abpni.co.uk>
To: "Vick Khera" <vivek@khera.org>,
	<pgsql-general@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.214 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FS_REPLICA=3.599, HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=0.001,
	RDNS_NONE=0.793, SARE_SPEC_REPLICA=0.72
X-Spam-Level: ***
X-Archive-Number: 201011/115
X-Sequence-Number: 169181

This is a multi-part message in MIME format.

------_=_NextPart_001_01CB7A99.7C0FD228
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


________________________________

From: pgsql-general-owner@postgresql.org on behalf of Vick Khera
Sent: Tue 02/11/2010 13:18
To: pgsql-general
Subject: Re: [GENERAL] Replication



On Tue, Nov 2, 2010 at 2:59 AM, Jonathan Tripathy <jonnyt@abpni.co.uk> =
wrote:
> What is the difference between the "Hot-Standby" and "Warm-Standby"? =
Is the
> only different that the "Hot-Standby" standby servers are read-only, =
whereas
> the "Warm-Standby" standbys can't be queried at all?
>

That's the general definition of those two terms as applied to a
database server.

-------------------------------------------------------------------------=
-----------------
Excellent!

In terms of streaming "Warm-Standby" replication, how much data loss =
will occur? Are we talking seconds, minutes, or hours? Let's assume a =
lightly used database (maybe 50 update queries an hour) and the master =
and slave are connected by Gigabit ethernet

Thanks





------_=_NextPart_001_01CB7A99.7C0FD228
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">=0A=
<HTML dir=3Dltr><HEAD><TITLE>Re: [GENERAL] Replication</TITLE>=0A=
<META content=3D"text/html; charset=3Dunicode" http-equiv=3DContent-Type>=0A=
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18975"></HEAD>=0A=
<BODY>=0A=
<DIV dir=3Dltr id=3DidOWAReplyText94942><BR>=0A=
<HR tabIndex=3D-1>=0A=
<FONT size=3D2 face=3DTahoma><B>From:</B> =
pgsql-general-owner@postgresql.org on =0A=
behalf of Vick Khera<BR><B>Sent:</B> Tue 02/11/2010 13:18<BR><B>To:</B> =0A=
pgsql-general<BR><B>Subject:</B> Re: [GENERAL] =
Replication<BR></FONT><BR></DIV>=0A=
<DIV>=0A=
<P><FONT size=3D2>On Tue, Nov 2, 2010 at 2:59 AM, Jonathan Tripathy =0A=
&lt;jonnyt@abpni.co.uk&gt; wrote:<BR>&gt; What is the difference between =
the =0A=
"Hot-Standby" and "Warm-Standby"? Is the<BR>&gt; only different that the =0A=
"Hot-Standby" standby servers are read-only, whereas<BR>&gt; the =
"Warm-Standby" =0A=
standbys can't be queried at all?<BR>&gt;<BR><BR>That's the general =
definition =0A=
of those two terms as applied to a<BR>database =0A=
server.<BR><BR>----------------------------------------------------------=
--------------------------------<BR></FONT><FONT =0A=
size=3D2>Excellent!</FONT></P><FONT size=3D2></FONT></DIV>=0A=
<DIV><FONT size=3D2>In terms of streaming "Warm-Standby" replication, =
how much =0A=
data loss will occur? Are we talking seconds, minutes, or hours? Let's =
assume a =0A=
lightly used database (maybe 50 update queries an hour) and the master =
and slave =0A=
are connected by Gigabit ethernet</FONT></DIV>=0A=
<P><FONT size=3D2>Thanks</P>=0A=
<DIV><BR></FONT><FONT size=3D2><BR></DIV></FONT></BODY></HTML>=0A=

------_=_NextPart_001_01CB7A99.7C0FD228--