<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi All ,<br>
I have successfully installed pgcluster 1.7 rc7 and it is working fine
. But i have got a doubt on " Single Point Failure " . <br>
<br>
I need a suggest from u all on this .<br>
<br>
For an Application which demands High Availability and no Single Point
Failure and built Multi-Master Replication system , is PGCLUSTER - II
a suitable option.<br>
<br>
Please suggest/support this issue .<br>
<br>
Thanks in advance .<br>
<br>
Best Regards,<br>
<br>
Trinath Somanchi wrote:
<blockquote cite="mid:46C95458.1070503@intoto.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Hi Tarhon ,<br>
<br>
Thank you for the reply ,<br>
<br>
I got pgCluster partially done.<br>
<br>
I have 2 servers 172.16.1.111 [Cluster DB and Replicator] and
172.16.1.121 [Cluster DB and Replicator] .<br>
<br>
When bot were ON , in 111 , i have inserted a row and it is replicated
in 121 also .<br>
<br>
TEST-1] Now I have shutdown the 111 db and replicator and inserted
another row in 121 server . Now i have started 111 db using -R option
, Recovery was done and is in sync with 121 .<br>
<br>
TEST-2] now I have shutdown the 121 db and replicator and inserted
another row in 111 server , but here I'm getting this error <br>
<br>
<table border="1" cellpadding="2" cellspacing="2" width="100%">
<tbody>
<tr>
<td valign="top">[psql_mstr@1mc121 data]$
/home/psql_master/psqldb/bin/pg_ctl -w -D
/home/psql_master/psqldb/data -o "-d 5 -i -R" -p
/home/psql_master/psqldb/bin/postmaster start<br>
waiting for server to start....DEBUG: postmaster: PostmasterMain:
initial environ dump:<br>
DEBUG: -----------------------------------------<br>
DEBUG: STAF_INSTANCE_NAME=STAF<br>
DEBUG: HOSTNAME=1mc121.intotoind.com<br>
DEBUG: SHELL=/bin/bash<br>
DEBUG: TERM=xterm<br>
DEBUG: HISTSIZE=1000<br>
DEBUG: SSH_CLIENT=172.16.1.111 60685 22<br>
DEBUG: STAFCONVDIR=/usr/local/staf/codepage<br>
DEBUG: SSH_TTY=/dev/pts/8<br>
DEBUG: USER=psql_mstr<br>
DEBUG: LD_LIBRARY_PATH=/usr/local/staf/lib<br>
DEBUG:
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:<br>
DEBUG:
PATH=/usr/kerberos/bin:/usr/local/staf/bin:/usr/local/bin:/bin:/usr/bin:/home/psql_master/bin<br>
DEBUG: MAIL=/var/spool/mail/psql_mstr<br>
DEBUG: _=/home/psql_master/psqldb/bin/postmaster<br>
DEBUG: PWD=/home/psql_master/psqldb/data<br>
DEBUG: INPUTRC=/etc/inputrc<br>
DEBUG: LANG=en_US.UTF-8<br>
DEBUG: PGSYSCONFDIR=/home/psql_master/psqldb/etc/postgresql<br>
DEBUG: SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass<br>
DEBUG: HOME=/home/psql_master<br>
DEBUG: SHLVL=2<br>
DEBUG: LOGNAME=psql_mstr<br>
DEBUG: CVS_RSH=ssh<br>
DEBUG: SSH_CONNECTION=172.16.1.111 60685 172.16.1.121 22<br>
DEBUG:
CLASSPATH=/usr/local/staf/lib/JSTAF.jar:/usr/local/staf/samples/demo/STAFDemo.jar<br>
DEBUG: PGDATA=/home/psql_master/psqldb/data<br>
DEBUG: LESSOPEN=|/usr/bin/lesspipe.sh %s<br>
DEBUG: G_BROKEN_FILENAMES=1<br>
DEBUG: LC_COLLATE=en_US.UTF-8<br>
DEBUG: LC_CTYPE=en_US.UTF-8<br>
DEBUG: LC_MESSAGES=en_US.UTF-8<br>
DEBUG: LC_MONETARY=C<br>
DEBUG: LC_NUMERIC=C<br>
DEBUG: LC_TIME=C<br>
DEBUG: -----------------------------------------<br>
Start in recovery mode!<br>
Please wait until a data synchronization finishes from Master DB...<br>
connection failed<br>
PGR_Recovery_Main() failed with cold recovery<br>
DEBUG: proc_exit(0)<br>
DEBUG: shmem_exit(0)<br>
DEBUG: exit(0)<br>
<br>
</td>
</tr>
</tbody>
</table>
<br>
I can manually do a rsync over ssh from both 111 and 121 as psql_mstr
user . Both have public keys exchanged.<br>
<br>
But TEST-2 fails , please help me to shoot out this problem . here are
the cluster.conf files present in 111 and 121 .<br>
<br>
<table border="1" cellpadding="2" cellspacing="2" width="100%">
<tbody>
<tr>
<td valign="top">-------------- cluster.conf
172.16.1.111--------------------------<br>
#============================================================<br>
# Cluster DB Server configuration file<br>
#------------------------------------------------------------<br>
# file: cluster.conf<br>
#------------------------------------------------------------<br>
# This file controls:<br>
# o which hosts & port are replication server<br>
# o which port use for replication request to replication server<br>
# o which command use for recovery function<br>
#============================================================<br>
#------------------------------------------------------------<br>
# set Replication Server information<br>
# o Host_Name : hostname<br>
# o Port : Connection port for postmaster<br>
# o Recovery_Port : Connection port for recovery
process<br>
#------------------------------------------------------------<br>
<Replicate_Server_Info><br>
<Host_Name> 1mc121.intotoind.com
</Host_Name><br>
<Port> 8001
</Port><br>
<Recovery_Port> 8101
</Recovery_Port><br>
</Replicate_Server_Info><br>
#<Replicate_Server_Info><br>
# <Host_Name> 1mc121.intotoind.com
</Host_Name><br>
# <Port> 8002
</Port><br>
# <Recovery_Port> 8102
</Recovery_Port><br>
#</Replicate_Server_Info><br>
#<Replicate_Server_Info><br>
# <Host_Name> replicate3.pgcluster.org
</Host_Name><br>
# <Port> 8003
</Port><br>
# <Recovery_Port> 8103
</Recovery_Port><br>
#</Replicate_Server_Info><br>
#-------------------------------------------------------------<br>
# set Cluster DB Server information<br>
# o Host_Name : Host name which connect with
replication server<br>
# o Recovery_Port : Connection port for recovery<br>
# o Rsync_Path : Path of rsync command<br>
# o Rsync_Option : File transfer option for rsync<br>
# o Rsync_Compress : Use compression option for rsync<br>
# [yes/no]. default : yes<br>
# o Pg_Dump_Path : Path of pg_dump<br>
# o When_Stand_Alone : When all replication servers
fell,<br>
# you can set up two kinds of
permission,<br>
# "real_only" or "read_write".<br>
# o Replication_Timeout : Timeout of each replication
request<br>
# o Lifecheck_Timeout : Timeout of the lifecheck
response<br>
# o Lifecheck_Interval : Interval time of the lifecheck<br>
# (range 1s - 1h)<br>
# 10s -- 10 seconds<br>
# 10min -- 10 minutes<br>
# 1h -- 1 hours<br>
#-------------------------------------------------------------<br>
<Host_Name> 1mc111.intotoind.com
</Host_Name><br>
<Recovery_Port> 7001
</Recovery_Port><br>
<Rsync_Path> /usr/bin/rsync
</Rsync_Path><br>
<Rsync_Option> ssh -l psql_mstr
</Rsync_Option><br>
<Rsync_Compress> yes
</Rsync_Compress><br>
<Pg_Dump_Path>
/home/psql_master/psqldb/bin/pg_dump </Pg_Dump_Path><br>
<When_Stand_Alone> read_write
</When_Stand_Alone><br>
<Replication_Timeout> 1 min
</Replication_Timeout><br>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout><br>
<LifeCheck_Interval> 11s
</LifeCheck_Interval><br>
#-------------------------------------------------------------<br>
# set partitional replicate control information<br>
# set DB name and Table name to stop reprication<br>
# o DB_Name : DB name<br>
# o Table_Name : Table name<br>
#-------------------------------------------------------------<br>
#<Not_Replicate_Info><br>
# <DB_Name> test_db </DB_Name><br>
# <Table_Name> log_table
</Table_Name><br>
#</Not_Replicate_Info><br>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<br>
<table border="1" cellpadding="2" cellspacing="2" width="100%">
<tbody>
<tr>
<td valign="top">-------------------cluster.conf for
172.16.1.121--------------------------------<br>
<br>
#============================================================<br>
# Cluster DB Server configuration file<br>
#------------------------------------------------------------<br>
# file: cluster.conf<br>
#------------------------------------------------------------<br>
# This file controls:<br>
# o which hosts & port are replication server<br>
# o which port use for replication request to replication server<br>
# o which command use for recovery function<br>
#============================================================<br>
#------------------------------------------------------------<br>
# set Replication Server information<br>
# o Host_Name : hostname<br>
# o Port : Connection port for postmaster<br>
# o Recovery_Port : Connection port for recovery
process<br>
#------------------------------------------------------------<br>
<Replicate_Server_Info><br>
<Host_Name> 1mc111.intotoind.com
</Host_Name><br>
<Port> 8001
</Port><br>
<Recovery_Port> 8101
</Recovery_Port><br>
</Replicate_Server_Info><br>
#<Replicate_Server_Info><br>
# <Host_Name> 1mc121.intotoind.com
</Host_Name><br>
# <Port> 8002
</Port><br>
# <Recovery_Port> 8102
</Recovery_Port><br>
#</Replicate_Server_Info><br>
#<Replicate_Server_Info><br>
# <Host_Name> replicate3.pgcluster.org
</Host_Name><br>
# <Port> 8003
</Port><br>
# <Recovery_Port> 8103
</Recovery_Port><br>
#</Replicate_Server_Info><br>
#-------------------------------------------------------------<br>
# set Cluster DB Server information<br>
# o Host_Name : Host name which connect with
replication server<br>
# o Recovery_Port : Connection port for recovery<br>
# o Rsync_Path : Path of rsync command<br>
# o Rsync_Option : File transfer option for rsync<br>
# o Rsync_Compress : Use compression option for rsync<br>
# [yes/no]. default : yes<br>
# o Pg_Dump_Path : Path of pg_dump<br>
# o When_Stand_Alone : When all replication servers
fell,<br>
# you can set up two kinds of
permission,<br>
# "real_only" or "read_write".<br>
# o Replication_Timeout : Timeout of each replication
request<br>
# o Lifecheck_Timeout : Timeout of the lifecheck
response<br>
# o Lifecheck_Interval : Interval time of the lifecheck<br>
# (range 1s - 1h)<br>
# 10s -- 10 seconds<br>
# 10min -- 10 minutes<br>
# 1h -- 1 hours<br>
#-------------------------------------------------------------<br>
<Host_Name> 1mc121.intotoind.com
</Host_Name><br>
<Recovery_Port> 7001
</Recovery_Port><br>
#<Rsync_Path>
/home/psql_master/psqldb/rsync </Rsync_Path><br>
<Rsync_Path> /usr/bin/rsync
</Rsync_Path><br>
<Rsync_Option> ssh -l psql_mstr
</Rsync_Option><br>
<Rsync_Compress> yes
</Rsync_Compress><br>
<Pg_Dump_Path>
/home/psql_master/psqldb/bin/pg_dump </Pg_Dump_Path><br>
<When_Stand_Alone> read_write
</When_Stand_Alone><br>
<Replication_Timeout> 1 min
</Replication_Timeout><br>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout><br>
<LifeCheck_Interval> 11s
</LifeCheck_Interval><br>
#-------------------------------------------------------------<br>
# set partitional replicate control information<br>
# set DB name and Table name to stop reprication<br>
# o DB_Name : DB name<br>
# o Table_Name : Table name<br>
#-------------------------------------------------------------<br>
#<Not_Replicate_Info><br>
# <DB_Name> test_db </DB_Name><br>
# <Table_Name> log_table
</Table_Name><br>
#</Not_Replicate_Info><br>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
</td>
</tr>
</tbody>
</table>
<br>
Thanks in advance ,<br>
<br>
Best Regards,<br>
Trinath Somanchi.<br>
<br>
<br>
Tarhon-Onu Victor wrote:
<blockquote
cite="mid:Pine.LNX.4.64.0708201019210.10439@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz"
type="cite">On Mon, 20 Aug 2007, Trinath Somanchi wrote: <br>
<br>
<blockquote type="cite">Rsync over ssh is working fine ,,,,,,,.I
have
manually tested it . <br>
<br>
Is there any way to find how rSync command is executed in PgCluster . <br>
<br>
Please help me in this regard, <br>
</blockquote>
<br>
One more thing to check: the path to the rsync command in your
cluster.conf configuration file (the Rsync_Path configuration
directive). <br>
<br>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<img src="cid:part1.05030007.01080402@intoto.com" border="0"></div>
<pre wrap="">_______________________________________________
Pgcluster-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgcluster-general@pgfoundry.org">Pgcluster-general@pgfoundry.org</a>
<a class="moz-txt-link-freetext" href="http://pgfoundry.org/mailman/listinfo/pgcluster-general">http://pgfoundry.org/mailman/listinfo/pgcluster-general</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<img src="cid:part2.04020506.03080407@intoto.com" border="0"></div>
</body>
</html>