"Brendan Jurd" <direvus@xxxxxxxxx> writes: > So, my question for the list is: is Slony + log shipping the direction > I should be investigating, or is there something else out that I ought > to consider? Those are two different methods: you'd use one or the other, not both. Slony-I is much the more battle-tested of the two at the moment. In theory WAL log shipping should be higher performance for heavy-update scenarios, but its latency is variable (low update rate = higher latency), and not easy to put a bound on pre-8.2. Have you looked at the replication info recently added to the PG docs? http://developer.postgresql.org/pgdocs/postgres/failover.html regards, tom lane
