Обсуждение: Question about replication options
I'm interested in having live replication from one server to another, and I've looked into many of the options out therebut 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 thedefinition of "schema changes." Am I wrong about that limitation of Slony-I, and if not does anyone here have a recommendation for a replication solutionthat would work for my situation? Thanks, Adam
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 therebut 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 schemachanges." Our schemas don't change after creation, but I am guessing that adding a schema to the database falls underthe 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 solutionthat 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
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 therebut 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 schemachanges." Our schemas don't change after creation, but I am guessing that adding a schema to the database falls underthe 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 solutionthat 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
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 therebut 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 schemachanges." Our schemas don't change after creation, but I am guessing that adding a schema to the database falls underthe 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 solutionthat 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