<div dir="ltr">Actually, node 2 is correct. I have 2 different clusters. Each cluster has node 1 and node 2. Each cluster replicates to 1 db.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 29, 2015 at 8:39 PM, Scott Marlowe <span dir="ltr"><<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Thu, Oct 29, 2015 at 6:06 PM, Sung Hsin Lei <<a href="mailto:sungh.lei@gmail.com">sungh.lei@gmail.com</a>> wrote:<br>
> Hello,<br>
><br>
</span><span class="">> I successfully update the main db and one replicated db with the following:<br>
><br>
> cluster name = slony_rep1<br>
><br>
> node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony1<br>
> password = Ejhfg33EdddsufhErR76 port = 6234';<br>
> node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.4 user = slony1<br>
> password = Ejhfg33EdddsufhErR76 port = 6234';<br>
><br>
> EXECUTE SCRIPT<br>
> (<br>
> SQL = 'ALTER TABLE operators RENAME COLUMN firstname TO lastname;',<br>
> EVENT NODE = 1<br>
> );<br>
><br>
><br>
><br>
><br>
> However, I have 1 main db to 2 replicated db. The second replicated db has<br>
> the following cluster name and node information:<br>
><br>
> cluster name = slony_rep2<br>
><br>
> node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony2<br>
> password = Ejhfg33EdddsufhErR76 port = 6234';<br>
> node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.17 user = slony2<br>
> password = Ejhfg33EdddsufhErR76 port = 6234';<br>
<br>
</span>Shouldn't that be node 3 not node 2?<br>
<span class=""><br>
> Do I need to run slonik twice with different cluster and node indo? That<br>
> does not seem right. After running the first time, the main db and the first<br>
> replicated db will be consistent but not the second replicated db. Also, if<br>
> I run it a second time, wouldn't the main db already be updated hence the<br>
> sql statements used for the original update will surely fail?<br>
<br>
</span>You can just run it on all three at once.<br>
<span class=""><br>
node 1 admin conninfo = 'dbname = MyDB host = localhost user = slony1<br>
password = Ejhfg33EdddsufhErR76 port = 6234';<br>
node 2 admin conninfo = 'dbname = MyDB host = 86.88.5.4 user = slony1<br>
password = Ejhfg33EdddsufhErR76 port = 6234';<br>
</span>node 3 admin conninfo = 'dbname = MyDB host = 86.88.5.17 user = slony2<br>
<span class="im HOEnZb">password = Ejhfg33EdddsufhErR76 port = 6234';<br>
<br>
</span><div class="HOEnZb"><div class="h5">EXECUTE SCRIPT<br>
(<br>
SQL = 'ALTER TABLE operators RENAME COLUMN firstname TO lastname;',<br>
EVENT NODE = 1<br>
);<br>
</div></div></blockquote></div><br></div>