Mon Jan 29 15:39:51 PST 2007
- Previous message: [Slony1-general] Log-shipping?
- Next message: [Slony1-general] Quizzical merge set error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
PREFACE: I've got replication running on 5 databases. On the largest, most active database ("pl"), I've setup the replication cluster's name to be "pl_replication". On the other four, I've setup the cluster's name as "replication". For each of the databases, I've got a configuration file, "conf/slon_tools-[dbname].conf" (thus, the config file for the aforementioned "pl" database is "conf/slon_tools-pl.conf"). The situation I'm about to explain happens on both servers (1 master, 1 slave), running on Slony 1.1.0 and 1.2.6. The servers, if it makes any difference (they're *identical*): * dual opteron 846 procs * 8G ram * SLES 8.1 (yeah, it's old) On the "pl_replication" cluster, running: ./bin/slon_kill \ --config=conf/slon_tools-pl.conf [eitherNode]" works just fine, killing only the slons on the current node for pl_replication. However, when I attempt to do the same thing for *any* of the databases that are part of the "replication" cluster, it kills *ALL* of the slon daemons (on the given node), regardless if they're attached to the specified database or not. At first, I'd thought that maybe our previous DBA had incorrectly broken-apart the replication sets, and that all of the four databases for the "replication" cluster were in fact supposed to have the same slon daemons. After some testing, however--I had plenty of time to do that, since the SAN attached to both of the DB's took a crap--I found that this does not *appear* to be the case. The only way that slony will actually replicate data for each of these databases is if each one is init'ed, slonned, sets created, and everyone is subscribed. So, I guess the question is: Am I missing something, or is slon_kill borken? -- Best Regards, Dan Falconer "Head Geek", AvSupport, Inc. (http://www.partslogistics.com)
- Previous message: [Slony1-general] Log-shipping?
- Next message: [Slony1-general] Quizzical merge set error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list