From: Jonathan Tripathy <jonnyt@abpni.co.uk>
To: Vick Khera <vivek@khera.org>
To: pgsql-general@postgresql.org
Subject: Re: Replication
Date: Tue, 2 Nov 2010 14:20:54 -0000
Message-ID: <46C13AA90DB8844DAB79680243857F0F0AFF07@server1.ABPNI.local> (raw)
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: 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: jonnyt@abpni.co.uk, vivek@khera.org
Subject: Re: Replication
In-Reply-To: <46C13AA90DB8844DAB79680243857F0F0AFF07@server1.ABPNI.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox