News for hackers. Stuff that matters.
Re:PostgreSQL 9.0b1 with built-in replication support by xal on Monday May 03, 2010 @08:40PM (#1316596)
Is the build in replication support able to correctly replicate schema changes to the slaves? That was the biggest issue with the existing solutions for most admins I talked to.
Re:PostgreSQL 9.0b1 with built-in replication support by thristian on Tuesday May 04, 2010 @12:50AM (#1317107)
It's based on shipping write-ahead-logs around, so anything you can do inside a transaction (pretty much any DML or DDL statements except for ones that affect the entire cluster, like "CREATE USER" or "DROP DATABASE") can be replicated.