I am not sure if this is still relevant for the person posting the
question. But I guess this can benefit others who browse through the
archives looking for a similar solution. Here is a link to a nice tutorial
with pgpool:
http://searchadmin.org/Thread-ha-postgresql-cluster-by-streaming-replication-pgpool-ii/
Though it looks like the pgpool in this tutorial is running on a different
server (and hence pgpool becomes a single point of failure).