From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Vick Khera
Sent: Tue 02/11/2010 13:18
To: pgsql-general
Subject: Re: Replication
On Tue, Nov 2, 2010 at 2:59 AM, Jonathan Tripathy
<jonnyt@xxxxxxxxxxx> 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
