<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="urn:schemas-microsoft-com:office:smarttags">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I would like to change the port on node1 from 5432 to
5433. Do I need to ‘start from scratch’<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And recreate the node and the entire set or is there an ‘update’
function I can use?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m running postgres 8.3.11 and slony1 2.0.5<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m running all my administration scripts from the
slonik library. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>./slonik_update_nodes and ./slonik_restart_nodes don’t
work. Think they update the internal functions.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> Here is a little bit of my slon_tools.conf file:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&add_node(node=>1, host => '192.168.1.222', dbname
=> 'mavmail', port =>5433, user=>'slony',
password=>'elephant1234');<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&add_node(node=>2, host => '192.168.1.221',
dbname => 'mavmail', port =>5432, user=>'slony',
password=>'elephant1234');<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Obviously would like to change the port on server
192.168.1.222 to 5433 without dropping and redefining everything.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any help appreciated. Thanks.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><font
size=1 color="#4f81bd" face="Century Gothic"><span style='font-size:8.0pt;
font-family:"Century Gothic";color:#4F81BD;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 color=gray face="Century Gothic"><span style='font-size:8.0pt;
font-family:"Century Gothic";color:gray'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 face="Times New Roman"><span style='font-size:8.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
title="blocked::http://www.autobase.net/"><span
title="blocked::http://www.autobase.net/"><b><font size=2 color=gray
face="Century Gothic"><span style='font-size:11.0pt;font-family:"Century Gothic";
color:gray;font-weight:bold'>Mark Steben<br>
</span></font></b><font size=1 color=gray face="Century Gothic"><span
style='font-size:8.0pt;font-family:"Century Gothic";color:gray'>Database
Administrator<br>
</span></font><b><font size=1 color="#4f81bd" face="Century Gothic"><span
style='font-size:8.0pt;font-family:"Century Gothic";color:#4F81BD;font-weight:
bold'>@utoRevenue | Autobase | AVV<br>
The CRM division of Dominion Dealer Solutions<br>
</span></font></b><st1:Street w:st="on"><st1:address w:st="on"><font size=1
color="#7f7f7f" face="Century Gothic"><span style='font-size:8.0pt;
font-family:"Century Gothic";color:#7F7F7F'>95D Ashley Avenue</span></font></st1:address></st1:Street><br>
<font size=1 face="Century Gothic"><span style='font-size:8.0pt;font-family:
"Century Gothic"'><ns0:place w:insAuthor="Mark Steben"
w:insDate="2011-02-15T14:24:00Z" w:endInsAuthor="Mark Steben"
w:endInsDate="2011-02-15T14:24:00Z"><st1:place w:st="on"><st1:City w:st="on"><font
color="#7f7f7f"><span style='color:#7F7F7F'>West Springfield</span></font></st1:City><font
color="#7f7f7f"><span style='color:#7F7F7F'>, </span></font><ns0:State
w:insAuthor="Mark Steben" w:insDate="2011-02-15T14:24:00Z"
w:endInsAuthor="Mark Steben" w:endInsDate="2011-02-15T14:24:00Z"><st1:State
w:st="on"><font color="#7f7f7f"><span style='color:#7F7F7F'>MA</span></font></st1:State></ns0:State><font
color="#7f7f7f"><span style='color:#7F7F7F'> </span></font><ns0:PostalCode
w:insAuthor="Mark Steben" w:insDate="2011-02-15T14:24:00Z"
w:endInsAuthor="Mark Steben" w:endInsDate="2011-02-15T14:24:00Z"><st1:PostalCode
w:st="on"><font color="#7f7f7f"><span style='color:#7F7F7F'>01089</span></font></st1:PostalCode></ns0:PostalCode></ns0:place></st1:place><font
color="#7f7f7f"><span style='color:#7F7F7F'><br>
t: 413.327.3045<br>
f: 413.732.1824<br>
</span></font><font color=gray><span style='color:gray'>w: <a
href="http://www.autorevenue.com/"
title="blocked::http://www.autorevenue.com/ http://www.autorevenue.com/">www.autorevenue.com</a><br>
<br>
</span></font></span></font><o:p></o:p></p>
</span></span>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>