<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:"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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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 Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1499690502;
mso-list-template-ids:-1214491830;}
@list l0:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</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-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>HI All,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Just thought it might be useful.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:11.05pt'><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>SLONY-I on Windows XP using Slony 1.2.16 and postgres 8.3<o:p></o:p></span></b></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Create 3 databases, master, slave1 and slave2 and ensure pl/pgsql
is setup in each.<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Create a schema with tables in the master database:<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Add a primary key to each table.<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Create a schema-only dump of the master database, and load it into
slave1 and slave2: <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>[This step needs to be followed
only if the slave does not exists already.]<br>
<br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
pg_dump -s -U postgres master > schema.sql [creates an sql file with
commands necessary to create tables and insert data in it with which we can
build the slave databases]</span><span style='font-size:10.0pt;font-family:
"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
psql -U postgres slave1 < schema.sql [slave database gets contructed]</span><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
psql -U postgres slave2 < schema.sql [slave database gets contructed]</span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Create Slony config files for each slon engine (daemon on *nix).
The files should contain just the following two lines:<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Contents of Master.conf<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>cluster_name='pgbench'</span><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>conn_info='host=ip
of master port=5432 user=postgres dbname=master' </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Contents of Slave.conf<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>cluster_name='pgbench'</span><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>conn_info='host=ip
slave port=5432 user=postgres dbname=master' </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>[Create a file for each
database, adjusting the dbname parameter as required and adding any other
connection options that may be needed. For the IP, it’s better to use
domain names to ensure that all servers are addressed uniformly in pgadmin and
slonyi]<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>6.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>(Windows only) Install the Slony-I service:<br>
<br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
slon -regservice Slony-I </span><span style='font-size:9.0pt;font-family:
"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>[Slony-II, Slony-II, Slony-A, etc could
also be used]</span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>7.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Register each of the engines (this is only necessary on Windows -
on *nix the slon daemons may be started individually and given the path to the
config file on the command line using the -f option):<br>
<br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
slon -addengine Slony-I C:\slony\master.conf</span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
slon -addengine Slony-I C:\slony\slave1.conf</span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'><br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
slon -addengine Slony-I C:\slony\slave2.conf </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:11.05pt'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>8.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>In pgAdmin under the Replication node in the master database,
create a new Slony-I cluster using the following options.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Create a cluster in the master
database<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Join existing
cluster: Unchecked<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Cluster
name: pgbench (any name)<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Local
node: 1 Master node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Admin
node: 99 Admin node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'> <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>9.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Under the Replication node, create a Slony-I cluster in each of
the slave databases using the following options:<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Join existing
cluster: Checked<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Server:
<Select the server containing the master database><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Database:
master<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Cluster
name: pgbench<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Local
node: 10 Slave node 1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Admin
node: 99 - Admin node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Join existing
cluster: Checked<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Server:
<Select the server containing the master database><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Database:
master<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Cluster
name: pgbench<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Local
node: 20 Slave node 2<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Admin
node: 99 - Admin node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'> <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>10.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Create
Paths on the master to both slaves, and on each slave back to the master.
Create the paths under each node on the master, using the connection strings
specified in the slon config files. Note that future restructuring of the
cluster may require additional paths to be defined.</span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'> </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Example <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Slave path in Master node
=>host=ip/ dns port=5432 user=postgres dbname=nlpg<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>Master path in slave node =>
host=ip/ dns port=5432 user=postgres dbname=nlpg</span><span style='font-size:
9.0pt;font-family:"Verdana","sans-serif";color:black'><br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>11.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Create a
Replication Set on the master using the following settings:</span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'> </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>ID:
1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Comment:
rep set1 (any name)<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>12.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Add the
tables to the replication set using the following [existing table names are
available from the drop down]:</span><span style='font-size:9.0pt;font-family:
"Verdana","sans-serif";color:black'> </span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Table:
public.accounts<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>ID:
1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Index:
accounts_pkey<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Table:
public.branches<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>ID:
2<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Index:
branches_pkey<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Table:
public.history<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>ID:
3<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Index:
history_pkey<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Table:
public.tellers<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>ID:
4<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Index:
tellers_pkey<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>[In this
approach all the tables are being added to one replication set in the master.
Alternatively, we can add n replication set for each table.]<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'> <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>13.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>On the
master node, create a new subscription for each slave using the following
options:<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Origin:
1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Provider:
1 - Master node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Receiver:
10 - Slave node 1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Origin:
1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Provider:
1 - Master node<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>Receiver:
20 - Slave node 2<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>With ‘Call
forward’ checked.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>[Need not repeat
this step for slave, since once the replication is up and running, the
replication sets are automatically created on the slave clusters.]<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:11.05pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:black'> <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>14.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Start
the slon service (or daemons on *nix):</span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'> </span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><br>
<br>
</span><span style='font-size:10.0pt;font-family:"Courier New";color:black'>>
net start Slony-I </span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>[Check if the slon service is up and
running using the windows taskbar]</span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'><br>
<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;text-indent:-18.0pt;line-height:11.05pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'><span
style='mso-list:Ignore'>15.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:black'>Open 2
command prompt windows on the path postgres/8.3/bin where slon is installed.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>In the first window, type the command
to bring the master database up.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>slon cluster_name
"host=ip/dns dbname=nlpg user=postgres password=abcdef"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>In the second window, type the
command to bring the slave database up and listening to the master slon.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>slon cluster_name "host=
ip/dns port=5432 dbname=nlpg user=postgres password=abcd"<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt;line-height:11.05pt'><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:black'>[Now, we have to wait until all
the tables from the replication set(s) in the master database are synchronised
with those in the slave database.Once the synchronisation is done, the
replication is ready to be tested.]<o:p></o:p></span></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>Regards,<o:p></o:p></p>
<p class=MsoNormal>Don<o:p></o:p></p>
<p class=MsoNormal>donsasikumar@gmail.com<o:p></o:p></p>
</div>
<br><br>
<P align=center><font color="#666666" size="-2" face="Arial, Helvetica, sans-serif">Intelligent Addressing Ltd. Registered Office: 1 Adam Street, London WC2N 6DD Reg. in England No.3863861 VAT No.GB 802258946</font></P>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been scanned for viruses by </FONT><A href="http://www.blackspider.com/"><FONT style="BACKGROUND-COLOR: #ffffff" color=#000000>BlackSpider MailControl</FONT></A></P>
</body>
</html>