Re: Replication mode

On 11/01/18 11:00, Peter Eisentraut wrote:

> 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.
>

We do talk about 'warm standby' in the docs:

https://www.postgresql.org/docs/10/static/warm-standby.html

...altho we do not precisely say how to setup this up as opposed to the 
'hot' variant. In fact it is pretty easy to (accidentally) get a warm 
standby by forgetting to set :

standby_mode = 'on'

in recovery.conf

Cheers

Mark