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 <kiwan2005(at)gmail(dot)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
杨晓青