<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 class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" 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 class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">the sl.node contains</font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span class="gmail-Apple-converted-space"> </span>no_id | no_active | no_comment | no_failed<span class="gmail-Apple-converted-space"> </span></font></span></p><p class="gmail-p1" style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">-------+-----------+------------+-----------</font></span></p><p class="gmail-p1" style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span class="gmail-Apple-converted-space"> </span>11 | t <span class="gmail-Apple-converted-space"> </span>| Node<span class="gmail-Apple-converted-space"> </span>11 <span class="gmail-Apple-converted-space"> </span>| f</font></span></p><p class="gmail-p1" style="margin:0px;font-style:normal;font-variant:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span class="gmail-Apple-converted-space"> </span>12 | t <span class="gmail-Apple-converted-space"> </span>| Node<span class="gmail-Apple-converted-space"> </span>12 <span class="gmail-Apple-converted-space"> </span>| f</font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">
</font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><span class="gmail-Apple-converted-space"> </span>13 | t <span class="gmail-Apple-converted-space"> </span>| Node<span class="gmail-Apple-converted-space"> </span>13 <span class="gmail-Apple-converted-space"> </span>| f</font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" 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 class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" 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><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif"><br></font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif">Thanks</font></span></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="times new roman, serif" style="">Tory</font></span></p></div></div>