Comment Re:Replication? (Score 5, Informative) 147
We use Slony. It is a delicate beast, but works quite well if you take time to read the limited documentation. You can use a kludge to keep schema changes in line: if you execute all schema changes through EXECUTE SCRIPT statements on the master server, all the slave nodes will get the schema changes. As for large object support, you're right; it is a problem.
PITR recovery and log replication may work in 8.2; but I agree with the posters who complain that there is no easy replication for postgresql.
PITR recovery and log replication may work in 8.2; but I agree with the posters who complain that there is no easy replication for postgresql.