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