Become a fan of Slashdot on Facebook


Forgot your password?

Comment: Re:Replication? (Score 5, Informative) 147

by nyamada (#17123508) Attached to: PostgreSQL 8.2 Released
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.

Elegance and truth are inversely related. -- Becker's Razor