From: | "Jonathan Tripathy" <jonnyt(at)abpni(dot)co(dot)uk> |
---|---|
To: | "Vick Khera" <vivek(at)khera(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Replication |
Date: | 2010-11-02 14:20:54 |
Message-ID: | 46C13AA90DB8844DAB79680243857F0F0AFF07@server1.ABPNI.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
________________________________
From: pgsql-general-owner(at)postgresql(dot)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(at)abpni(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michal Politowski | 2010-11-02 14:21:57 | Re: index in desc order |
Previous Message | Tom Lane | 2010-11-02 14:10:19 | Re: index in desc order |