Adam Tucker wrote: > I'm interested in having live replication from one server to another, and > I've looked into many of the options out there but I'm unclear on one part of > it. The way our database works is that each individual user account has > their own schema. When a new user signs up, a new schema is created and > populated with basic data. > > Slony-I seemed like a good option, but in the documentation it states that it > "does not automatically propagate schema changes." Our schemas don't change > after creation, but I am guessing that adding a schema to the database falls > under the definition of "schema changes." > > Am I wrong about that limitation of Slony-I, and if not does anyone here have > a recommendation for a replication solution that would work for my situation?
You are wrong. It means you cannot simply alter a replicated table on the origin and have it altered automatically on the replica (but you can do it with some manual labour). If you want to replicate a new set of tables, you can do that easily. I imagine you've already been flamed to death about the one-schema-per-user bit so I won't say anything about that. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
