'pg_ha' is a collection of scripts for setting up and running PostgreSQL in High Availability on FreeBSD. I've worked on for some time, and it is a relatively complex setup. You'll find the documentation here.
The setup uses the following tools:
- FreeBSD (but any UNIX/Linux distribution should work with some modifications)
- PostgreSQL with Streaming Replication
- PGPool-II
- UCARP