This document may help you. http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html
see "Failover with Streaming Replication" section. 2012/2/13 Wissem <kiwan2...@gmail.com> > > Hello, > > I am new user of Postgresql, I have successfully set up a Hot Standby / > Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql > version 9.1). > > I need to set up an automatic failover and discovered that there is a tool > named; pgpool. I have searched a lot on the net and didn't found a useful > article (step by step) to setup it. > > Could you please help me and share any useful document with me? > > thanks, > > W > > > -- ------------------------------------------- best regards 杨晓青