<div dir="ltr"><div dir="ltr">On Wed, Oct 16, 2019 at 1:39 PM Tory M Blue <<a href="mailto:tmblue@gmail.com">tmblue@gmail.com</a>> wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font face="times new roman, serif">I'm doing another migration , but this time I'm keeping the same host names, so that I'm not forcing configuration changes in our various applications.</font><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">This means that </font></div><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">nodes 1-4 are currently subscribed and have their hostnames in the config. We use scripts that call a file to get the host, it's db and password</font></div><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">When I go to add nodes</font></div><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">11-14, I'm using the syntax, where xxx is the IP (not the hostname)</font></div><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">Node, hostname</font></div><div><font face="times new roman, serif">11, xxx.xxx.xxx.xxx</font></div><div><font face="times new roman, serif">12, xxx,xxx,xxx,xxx</font></div><div><font face="times new roman, serif">etc</font></div><div><font face="times new roman, serif"><br></font></div><div><font face="times new roman, serif">the sl.path looks like this:</font></div><div><font face="times new roman, serif"><br></font></div><div>
<p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">dbname=clsdb host=xxx.xxx.xxx.xxx user=postgres</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">the sl.node contains</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span> </span>no_id | no_active | no_comment | no_failed<span> </span></font></span></p><p style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">-------+-----------+------------+-----------</font></span></p><p style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span> </span>11 | t <span> </span>| Node<span> </span>11 <span> </span>| f</font></span></p><p style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span> </span>12 | t <span> </span>| Node<span> </span>12 <span> </span>| f</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">
</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span> </span>13 | t <span> </span>| Node<span> </span>13 <span> </span>| f</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">Wondering if there is a way to change the sl_path to be the hostname vs the IP (it will be the same, but does slony care?) Can I just alter the line in the sl_path and change IP to hostname without everything blowing up (given that I put the right hostname for that particular IP and of course it's in DNS)??</font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">Thinking through this more, this actually may not be an issue, as I'm thinking if I change hosts i'm added and dropping and can add the hostname at that time, but something is bothering me about leaving it as the IP (although in reality it's not going to change unless it's dropped). Well ignore the fact that this may not be warranted and focus on whether I can make the edits without causing mass hysteria</font></span></p></div></div></blockquote><div><br></div><div>I *think* if you run the slonik command "store node" on an already-existing cluster, it'll just update the comment in no_comment.</div><div><br></div><div>That's consistent with:</div><div>a) The code in storeNode_int(node_id, comment)</div><div><br></div><div>b) The code in storeNode(node_id, comment)</div><div><br></div><div>c) Uh oh. Not so consistent with the slonik code; that wants to run initializeLocalNode(), which will be unhappy at there being a node there already.</div><div><br></div><div>But I suspect if you ran the function storeNode(id, comment), that might well do what you're wanting, as that captures the data as an event to propagate, and runs the storeNode_int() function locally, which would go off and populate the node comment everywhere.<br></div></div></div>