'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