On 10/29/2015 09:49 PM, Sung Hsin Lei wrote: > Actually, node 2 is correct. I have 2 different clusters. Each cluster > has node 1 and node 2. Each cluster replicates to 1 db.
What is the reason for this setup? If the two slaves are subscribed to different sets of tables, then the same can be achieved by creating multiple sets and subscribing the slaves to individual combinations of them. Regards, Jan > > On Thu, Oct 29, 2015 at 8:39 PM, Scott Marlowe <scott.marl...@gmail.com > <mailto:scott.marl...@gmail.com>> wrote: > > On Thu, Oct 29, 2015 at 6:06 PM, Sung Hsin Lei <sungh....@gmail.com > <mailto:sungh....@gmail.com>> wrote: > > Hello, > > > > I successfully update the main db and one replicated db with the > following: > > > > cluster name = slony_rep1 > > > > node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony1 > > password = Ejhfg33EdddsufhErR76 port = 6234'; > > node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.4 user = slony1 > > password = Ejhfg33EdddsufhErR76 port = 6234'; > > > > EXECUTE SCRIPT > > ( > > SQL = 'ALTER TABLE operators RENAME COLUMN firstname TO lastname;', > > EVENT NODE = 1 > > ); > > > > > > > > > > However, I have 1 main db to 2 replicated db. The second replicated db > has > > the following cluster name and node information: > > > > cluster name = slony_rep2 > > > > node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony2 > > password = Ejhfg33EdddsufhErR76 port = 6234'; > > node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.17 user = slony2 > > password = Ejhfg33EdddsufhErR76 port = 6234'; > > Shouldn't that be node 3 not node 2? > > > Do I need to run slonik twice with different cluster and node indo? That > > does not seem right. After running the first time, the main db and the > first > > replicated db will be consistent but not the second replicated db. > Also, if > > I run it a second time, wouldn't the main db already be updated hence > the > > sql statements used for the original update will surely fail? > > You can just run it on all three at once. > > node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony1 > password = Ejhfg33EdddsufhErR76 port = 6234'; > node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.4 user = slony1 > password = Ejhfg33EdddsufhErR76 port = 6234'; > node 3 admin conninfo = 'dbname = MyDB host = 86.88.5.17 user = slony2 > password = Ejhfg33EdddsufhErR76 port = 6234'; > > EXECUTE SCRIPT > ( > SQL = 'ALTER TABLE operators RENAME COLUMN firstname TO lastname;', > EVENT NODE = 1 > ); > > > > > _______________________________________________ > Slony1-general mailing list > Slony1-general@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > -- Jan Wieck Senior Software Engineer http://slony.info _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
