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.
[ Parent
| on HN ]
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.