<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> Hi all.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> After doing a bit of googling on changing the IP address of the master and slave database servers being replicated by Slony, I’m still a bit confused on how to change the address. To give some background, I have 2 servers running PostgreSQL 8.4, and replication works fine between the database on each server. These are currently connected via crossover cable, just for the initial seed of the database (it’s roughly 300GB in size).<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> The slave database is going to be moved to a DR location, and kept up to date real time with Slony; however, the IP address of the master and slave servers are going to change. I currently have the following set up to set up to do the initial seed:<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>CLUSTER=my_cluster<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>DB1=trans<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>DB2=trans<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>H1=10.0.1.1<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>H2=10.0.1.2<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>U=postgres<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>slonik << _EOF_<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>cluster name = $CLUSTER;<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U';<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U';<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>init cluster (id = 1, comment = 'TRANS database on 10.0.1.1');<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>create set (id = 1, origin = 1,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> comment = 'TRANS database');<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>set add table…<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>…<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>…<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>…<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>store node (id = 2, comment = 'TRANS database on 10.0.1.2', event node = 1);<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>store path (server = 1, client = 2,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> conninfo = 'dbname=$DB1 host=$H1 user=$U');<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>store path (server = 2, client = 1,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> conninfo = 'dbname=$DB2 host=$H2 user=$U');<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>store listen (origin = 1, provider = 1, receiver = 2);<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>store listen (origin = 2, provider = 2, receiver = 1);<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'>_EOF_<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> Would I just need to change the IP addresses in the variables above? If so, would the “create set” and “set add table” calls still need to be in there? If those calls do need to be there, wouldn’t they error because they already exist for the cluster? When I try to change the IP addresses in the variables above and comment out the create set and set add table calls, I get:<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><stdin>:22: Error: namespace “_my_cluster” already exists in database of node 2<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> If I drop the cluster there, the seed would have to be redone. So is there anything else I’m missing here?<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'> Brad<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#7F7F7F'><o:p> </o:p></span></p></div><p style="font-family:arial;font-size: x-small;font-style:italic">
* This e-mail and any files transmitted with it may contain confidential and/or privileged information and intended solely for the use of the individual or entity to whom they are addressed. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message.
</p>
</body></html>