I am having Postgresql 8 installed on 2 RH Linux box. I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server.
I am having one question about the synchronization. How to keep another server in updated mode? It should takes an updated db from first server and restore it on another server.