<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Eras Demi ITC";
panose-1:2 11 8 5 3 5 4 2 8 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;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:374472916;
mso-list-type:hybrid;
mso-list-template-ids:-1605621276 648724422 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</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=Section1>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am using slony-2.0.4 with PostgreSQL 8.4 in Windows Xp. I
have two machines –A and B , where A acts as master and B acts as slave. <o:p></o:p></p>
<p class=MsoNormal>The script is like,<o:p></o:p></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>cluster name = sql_cluster;<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>node 1 admin conninfo = 'dbname=postgres
host=10.1.28.69 port=5432 user=postgres password=sa123!';<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>node 2 admin conninfo = 'dbname=postgres
host=10.1.28.33 port=5432 user=postgres password=sa123!';<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'><o:p> </o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>init cluster (id = 1, comment = 'Node 1');<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'><o:p> </o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>create set (id = 1, origin = 1, comment = 'Test
table');<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>set add table (set id =1, origin = 1, id = 2,full
qualified name = 'public.test', comment = 'Table Test1', Key='test_pkey');<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'><o:p> </o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>store node (id = 2, comment = 'Node 2', event
node=1);<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>store path (server = 1, client = 2,conninfo =
'dbname=postgres host=10.1.28.69 user=postgres password=sa123!');<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>store path (server = 2, client = 1, conninfo =
'dbname=postgres host=10.1.28.33 port=5432 user=postgres password=sa123!');<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'><o:p> </o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>store listen (origin = 1, provider = 1, receiver =
2);<o:p></o:p></span></i></p>
<p class=MsoNormal><i><span style='font-size:8.0pt;font-family:"Courier New"'>store
listen (origin = 2, provider = 2, receiver = 1);<o:p></o:p></span></i></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When the machine A is failed the slave machine B is promoted
to master . The promotion script is like,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>cluster name = sql_cluster;<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>node 1 admin conninfo = 'dbname=postgres host=10.20.30.2
port=5432 user=postgres';<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>node 2 admin conninfo = 'dbname=postgres host=10.20.30.3
port=5432 user=postgres';<o:p></o:p></span></i></p>
<p class=MsoNormal style='text-autospace:none'><i><span style='font-size:8.0pt;
font-family:"Courier New"'>failover (id = 1, backup node = 2);<o:p></o:p></span></i></p>
<p class=MsoNormal><i><span style='font-size:8.0pt;font-family:"Courier New"'>drop
node(id = 1, event node = 2);<o:p></o:p></span></i></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal>My requirement is that, <o:p></o:p></p>
<p class=MsoNormal>I have to reconnect the Machine A to the replication set, and
then make the machine A master and Machine B slave. Please help me to
create the script for this.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>[ when the machine A is connected again, the cluster is
already present in the ‘<i>master’</i> database. When I tried
to start the slony service in Machine A the cluster get removed. How can I subscribe
Machine A]<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Eras Demi ITC","sans-serif"'>Thanks
& Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Eras Demi ITC","sans-serif"'>Vishnu
S<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<DIV> </DIV>***** Confidentiality Statement/Disclaimer *****<br><br>This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.<br>The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.</body>
</html>