But with hot standby my slave will be in read-only mode ...how can I just use my slave as a backup and not do any read operation and let my primary server do all read and write operation. If my primary fails I will do manual failover. The whole idea is to remove any 3rd party open source tools as we are not sure how well they behave and avoid any single point of failure.
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.
...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 :
