<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 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
{font-family:Arial;
color:windowtext;}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</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'>Hi All,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We were configuring the Postgres clustering in Linux (Red
hat 5) with following configuration</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<ol start=1 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Cluster DB 1 (hostname – tstmach4)</span></font></li>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Cluster DB 2(hostname – tstmach5)</span></font></li>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Replication server 1(hostname-tstmach1)</span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Load balancer is
avoided and all are running on different machines</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Following are steps followed for
setup</span></font></p>
<ol start=1 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Postgres 8.3.1+pgcluster-1.9.0rc5-patch are installed
in each of the above machines as per the link <a
href="http://pgcluster.projects.postgresql.org/1_3/install.html">http://pgcluster.projects.postgresql.org/1_3/install.html</a></span></font></li>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Configured the cluster.conf under /usr/local/pgsql/data
in cluster DB1 and Cluster DB2 with respective cluster and replication
server details(sample is as shown below)</span></font> <font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'><a
href="http://pgcluster.projects.postgresql.org/1_3/db_conf.html">http://pgcluster.projects.postgresql.org/1_3/db_conf.html</a></span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td width=590 valign=top style='width:6.15in;border:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Replicate_Server_Info></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
<Host_Name>
tstmach1 </Host_Name></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
<Port>
8001
</Port></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>
<Recovery_Port>
8102
</Recovery_Port></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'></Replicate_Server_Info></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Host_Name>
tstmach 5
</Host_Name></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Recovery_Port>
7001
</Recovery_Port></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Rsync_Path>
/usr/bin/rsync
</Rsync_Path></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Rsync_Option>
ssh
-1
</Rsync_Option></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Rsync_Compress>
yes
</Rsync_Compress></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Rsync_Timeout>
10min
</Rsync_Timeout></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Rsync_Bwlimit>
0KB
</Rsync_Bwlimit></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Pg_Dump_Path>
/usr/local/pgsql/bin/pg_dump </Pg_Dump_Path></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Ping_Path>
/bin/ping
</Ping_Path></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><When_Stand_Alone>
read_only
</When_Stand_Alone></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><Replication_Timeout>
1min
</Replication_Timeout></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><LifeCheck_Timeout>
3s
</LifeCheck_Timeout></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><LifeCheck_Interval>
11s
</LifeCheck_Interval></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<ol start=3 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Configured the pgreplicate.conf with respective
replication and cluster details(sample is as shown below)</span></font></li>
</ol>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td width=590 valign=top style='width:6.15in;border:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Cluster_Server_Info></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Host_Name>
tstmach4 </Host_Name></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Port>
5432
</Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Recovery_Port>
7001
</Recovery_Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'></Cluster_Server_Info></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Cluster_Server_Info></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Host_Name>
tstmach5 </Host_Name></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Port>
5432
</Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
<Recovery_Port>
7001
</Recovery_Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'></Cluster_Server_Info></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Host_Name>
tstmach1
</Host_Name></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Replication_Port>
8001
</Replication_Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Recovery_Port>
8101
</Recovery_Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><RLOG_Port>
8301
</RLOG_Port></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Response_Mode>
normal
</Response_Mode></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Use_Replication_Log>
no
</Use_Replication_Log></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><Replication_Timeout>
1min
</Replication_Timeout></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><LifeCheck_Timeout>
3s
</LifeCheck_Timeout></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><LifeCheck_Interval>
15s
</LifeCheck_Interval></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Note: <b><span style='font-weight:
bold'>/usr/local/pgsql/etc</span></b> folder was not created during
installation. Hence we created the same and proceed with setup <a
href="http://pgcluster.projects.postgresql.org/1_3/pgrp_conf.html">http://pgcluster.projects.postgresql.org/1_3/pgrp_conf.html</a></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<ol start=4 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The /etc/hosts, pg_hba.conf files were updated with IP
and hostname of all the components in the environment.</span></font></li>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Following command were executed at replication server</span></font></li>
<ul type=disc>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data</span></font></li>
</ul>
</ol>
<p class=MsoNormal style='margin-left:.75in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>on running this 3 instances of
Postgres are running</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<ol start=5 type=1>
<ul type=disc>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>$ /usr/local/pgsql/bin/pgreplicate -D
/usr/local/pgsql/etc</span></font></li>
</ul>
</ol>
<p class=MsoNormal style='margin-left:.75in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>following error message is displayed
once the above command is executed</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>pid file /usr/local/pgsql/etc/pgreplicate.pid
found. is another pgreplicate running?bash-3.1$</span></font></b></p>
<p class=MsoNormal style='margin-left:.75in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'> </span></font></b></p>
<ol start=6 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Following command are executed at Cluster nodes</span></font></li>
<ul type=disc>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
-o "-i" start</span></font></li>
</ul>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>and the databases start successfully</span></font></p>
<ol start=7 type=1>
<li class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>On running the following at cluster DB 1</span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=1 color="#333333"
face=Courier><span lang=EN style='font-size:8.5pt;font-family:Courier;
color:#333333;font-weight:bold'>createdb testdb</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=1 color="#333333"
face=Courier><span lang=EN style='font-size:8.5pt;font-family:Courier;
color:#333333'>the following error is displayed at the other Db</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=1 color="#333333"
face=Courier><span lang=EN style='font-size:8.5pt;font-family:Courier;
color:#333333;font-weight:bold'>PGReplication failed</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=1 color="#333333"
face=Courier><span lang=EN style='font-size:8.5pt;font-family:Courier;
color:#333333;font-weight:bold'>STATEMENT Set DateStyle=ISO</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=1 color="#333333"
face=Courier><span lang=EN style='font-size:8.5pt;font-family:Courier;
color:#333333'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>And when try to connect to
Replication server from a client(Squirrel) following warning message is
displayed at replication server</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>WARNING: This
query is not permitted without running replication server</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>And the following at client</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>org.postgresql.util.PSQLException:
An I/O error occured while sending to the backend.</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'> </span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>So please let us know
how to resolve the issue and is non inclusion of load balancer is cause for
above.</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'> </span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Thanks in advance</span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'> </span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Regards,</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Sunitha S</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'> </span></font></b></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
</div>
</body>
</html>
<table><tr><td bgcolor=#ffffff><font color=#000000>This email message and its attachments may contain CONFIDENTIAL AND PRIVILEGED INFORMATION intended for the sole use of the addressee(s). If you have received it in error, please contact the sender by return email, notify your system manager and destroy the original message and any copies thereof. Any review, use, disclosure or distribution is unlawful. Please check this email and any attachments for the presence of viruses. The Company accepts no liability for any damage caused by any virus transmitted by this email. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company.<br>
The Company reserves the right to monitor, review and store the content of all messages sent to or from this e-mail address. <br>
<br>
www.aztecsoft.com<br>
</font></td></tr></table>