Hi, erverybody
I use pgcluster-1.5.0rc21 to build master-master DB. After started
pgreplications and clusters, I found
"192.168.0.3:33794 218.83.175.154:8001" used "netstat -ant".
there is not anything else need to connect the ip except the pgcluster.
Where should I modify or config to avoid that ?
replication1 <--------> replication2
| |
===================================
| |
| |
cluster1 cluster2
cluster1 and relication1 : 192.168.0.2
cluster2 and replication2 : 192.168.0.3
my configure file:
on 192.168.0.2
#============================================================
# Cluster DB Server configuration file
#------------------------------------------------------------
# file: cluster.conf
#------------------------------------------------------------
# This file controls:
# o which hosts & port are replication server
# o which port use for replication request to replication server
# o which command use for recovery function
#============================================================
<Replicate_Server_Info>
<Host_Name> rep_l </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101
</Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
<Host_Name> rep_2 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101
</Recovery_Port>
</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB Server information
#-------------------------------------------------------------
<Host_Name> cluster_1 </Host_Name>
<Recovery_Port> 7001
</Recovery_Port>
<Rsync_Path> /usr/bin/rsync
</Rsync_Path>
<Rsync_Option> ssh -1
</Rsync_Option>
<Rsync_Compress> yes
</Rsync_Compress>
<Rsync_Timeout> 10min
</Rsync_Timeout>
<Rsync_Bwlimit> 0KB
</Rsync_Bwlimit>
<Pg_Dump_Path> /opt/mookr/pgcluster/bin/pg_dump
</Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only
</When_Stand_Alone>
<Replication_Timeout> 1min
</Replication_Timeout>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout>
<LifeCheck_Interval> 11s
</LifeCheck_Interval>
##-------------------------------------------------------------
## set partitional replicate control information
## set DB name and Table name to stop reprication
## o DB_Name : DB name
## o Table_Name : Table name
##-------------------------------------------------------------
#<Not_Replicate_Info>
# <DB_Name> test_db </DB_Name>
# <Table_Name> log_table </Table_Name>
#</Not_Replicate_Info>
#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# A setup of Cluster DB(s)
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> cluster_1 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001
</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> cluster_2 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001
</Recovery_Port>
</Cluster_Server_Info>
#-------------------------------------------------------------
# A setup of Load Balance Server
#-------------------------------------------------------------
#<LoadBalance_Server_Info>
# <Host_Name> master </Host_Name>
# <Recovery_Port> 6001
</Recovery_Port>
#</LoadBalance_Server_Info>
#<LoadBalance_Server_Info>
# <Host_Name> slave01 </Host_Name>
# <Recovery_Port> 6001
</Recovery_Port>
#</LoadBalance_Server_Info>
#-------------------------------------------------------------
# A setup of a replication server
#-------------------------------------------------------------
<Host_Name> rep_1 </Host_Name>
<Replication_Port> 8001
</Replication_Port>
<Recovery_Port> 8101
</Recovery_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Response_Mode> normal
</Response_Mode>
<Use_Replication_Log> no
</Use_Replication_Log>
<Replication_Timeout> 1min
</Replication_Timeout>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout>
<LifeCheck_Interval> 15s
</LifeCheck_Interval>
#-------------------------------------------------------------
# A setup of a log files
#-------------------------------------------------------------
<Log_File_Info>
<File_Name> /var/log/postgresql/pgreplicate.log
</File_Name>
<File_Size> 1M </File_Size>
<Rotate> 3 </Rotate>
</Log_File_Info>
on 192.168.0.3
#============================================================
# Cluster DB Server configuration file
#------------------------------------------------------------
# file: cluster.conf
#------------------------------------------------------------
# This file controls:
# o which hosts & port are replication server
# o which port use for replication request to replication server
# o which command use for recovery function
#============================================================
<Replicate_Server_Info>
<Host_Name> rep_l </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101
</Recovery_Port>
</Replicate_Server_Info>
<Replicate_Server_Info>
<Host_Name> rep_2 </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101
</Recovery_Port>
</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB Server information
#-------------------------------------------------------------
<Host_Name> cluster_2 </Host_Name>
<Recovery_Port> 7001
</Recovery_Port>
<Rsync_Path> /usr/bin/rsync
</Rsync_Path>
<Rsync_Option> ssh -1
</Rsync_Option>
<Rsync_Compress> yes
</Rsync_Compress>
<Rsync_Timeout> 10min
</Rsync_Timeout>
<Rsync_Bwlimit> 0KB
</Rsync_Bwlimit>
<Pg_Dump_Path> /opt/mookr/pgcluster/bin/pg_dump
</Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only
</When_Stand_Alone>
<Replication_Timeout> 1min
</Replication_Timeout>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout>
<LifeCheck_Interval> 11s
</LifeCheck_Interval>
##-------------------------------------------------------------
## set partitional replicate control information
## set DB name and Table name to stop reprication
## o DB_Name : DB name
## o Table_Name : Table name
##-------------------------------------------------------------
#<Not_Replicate_Info>
# <DB_Name> test_db </DB_Name>
# <Table_Name> log_table </Table_Name>
#</Not_Replicate_Info>
#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# A setup of Cluster DB(s)
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> cluster_1 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001
</Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> cluster_2 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7001
</Recovery_Port>
</Cluster_Server_Info>
#-------------------------------------------------------------
# A setup of Load Balance Server
#-------------------------------------------------------------
#<LoadBalance_Server_Info>
# <Host_Name> master </Host_Name>
# <Recovery_Port> 6001
</Recovery_Port>
#</LoadBalance_Server_Info>
#<LoadBalance_Server_Info>
# <Host_Name> slave01 </Host_Name>
# <Recovery_Port> 6001
</Recovery_Port>
#</LoadBalance_Server_Info>
#-------------------------------------------------------------
# A setup of a replication server
#-------------------------------------------------------------
<Host_Name> rep_2 </Host_Name>
<Replication_Port> 8001
</Replication_Port>
<Recovery_Port> 8101
</Recovery_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Response_Mode> normal
</Response_Mode>
<Use_Replication_Log> no
</Use_Replication_Log>
<Replication_Timeout> 1min
</Replication_Timeout>
<LifeCheck_Timeout> 3s
</LifeCheck_Timeout>
<LifeCheck_Interval> 15s
</LifeCheck_Interval>
#-------------------------------------------------------------
# A setup of a log files
#-------------------------------------------------------------
<Log_File_Info>
<File_Name> /var/log/postgresql/pgreplicate.log
</File_Name>
<File_Size> 1M </File_Size>
<Rotate> 3 </Rotate>
</Log_File_Info>
--
Don't tell me how many the enemies,but where they are!
(ADV:Perl -- It's like Java, only it lets you deliver on time and under
budget.)
_______________________________________________
Pgcluster-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgcluster-general
