There are several approaches on replication/failover - you might have heard of Slony, Londiste, pgPool and some other tools. WAL Replication is different from all of them in one aspect - it doesn't let you query slave database (until 9.0, in ...