Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication mode - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Replication mode
Date
Msg-id ec6b33ee-e6da-bde5-5c42-c15b847a5b30@2ndquadrant.com
Whole thread Raw
In response to Replication mode  (Azimuddin Mohammed <azimeiu@gmail.com>)
Responses Re: Replication mode  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-admin
Tree view 
On 1/10/18 15:24, Azimuddin Mohammed wrote:
> May I know what is the core difference between HOT standby. Warm Stand by ?

In PostgreSQL, "hot standby" is a mode for an instance in recovery that
allows read-only commands to be executed on it.  The term "warm standby"
is not used by PostgreSQL, but you could think of a server in recovery
that does not allow queries to be a warm standby, if you wish.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-admin by date:

Previous
From: David Steele
Date:
Subject: Re: Broken replication in 3 node setup, master halt, standby 1promoted, standby 2 - replication not working
Next
From: Mark Kirkwood
Date:
Subject: Re: Replication mode