On Mon, 2009-12-07 at 13:29 -0500, 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."
You will have to create the schema on the origin and subscriber and then enable replication on that schema. > > 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? > > Thanks, > Adam -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin