[pgcluster: 99] Re: solaris8環境でのレプリケーションサーバの動作について
kazunari takahashi
kazunari.takahashi ＠ ctc-g.co.jp
2004年 2月 19日 (木) 11:39:38 JST
高橋です．
お忙しい中、対応ありがとうございます．
IPアドレスのネットワークアドレスは公表できないため、変更しております．
また、/etc/hostsファイルの全てを見せれないとめ、必要な情報だけ抜き出してあります．
以上 宜しくお願い致します．
> 差し支えなければ，以下の情報を教えてください．
> ホスト名：awamori
> /etc/hosts
> /usr/local/pgsql/etc/pgreplicate.conf
> hostnameコマンドの結果
----------------------------
/etc/hosts
----------------------------
awamori% more /etc/hosts
#
# Internet host table
#
127.0.0.1 localhost
192.168.1.190 awamori loghost
192.168.1.59 king-kazu
192.168.1.222 ora01
awamori% more /etc/hosts | grep king-kazu
192.168.1.59 king-kazu
awamori% more /etc/hosts | grep awamori
192.168.1.190 awamori loghost
awamori% more /etc/hosts | grep ora01
192.168.1.222 ora01
----------------------------
replicatin.conf
----------------------------
awamori% more /usr/local/pgsql/etc/pgreplicate.conf
#============================================================
# PGReplicate configuration file
#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# This file controls:
# o which hosts & port are cluster server
# o which port use for replication request from cluster server
#============================================================
#-------------------------------------------------------------
# set cluster DB server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Recovery_Port : connection for recovery
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> ora01 </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> king-kazu </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7779 </Recovery_Port>
</Cluster_Server_Info>
#<Cluster_Server_Info>
# <Host_Name> post3.postgres.jp </Host_Name>
# <Port> 5432 </Port>
# <Recovery_Port> 7779 </Recovery_Port>
#</Cluster_Server_Info>
#-------------------------------------------------------------
# set Load Balance server information
# o Host_Name : hostname
# o Recovery_Port : connection for recovery
#-------------------------------------------------------------
#<LoadBalance_Server_Info>
# <Host_Name> loadbalancer.postgres.jp </Host_Name>
# <Recovery_Port> 7780 </Recovery_Port>
#</LoadBalance_Server_Info>
#-------------------------------------------------------------
# set PGReplicate server information
# o Replicate_Port : connection for reprication
# o Recovery_Port : connection for recovery
#-------------------------------------------------------------
<Replication_Port> 8777 </Replication_Port>
<Recovery_Port> 7778 </Recovery_Port>
----------------------------
hostname,uname -a
----------------------------
awamori% hostname
awamori
awamori% uname -a
SunOS awamori 5.8 Generic_108528-23 sun4u sparc SUNW,UltraAX-i2
----------------------------
ssh ,rsync
----------------------------
awamori% ssh ora01
Last login: Thu Feb 19 11:19:12 2004 from king-kazu
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
ora01% exit
Connection to ora01 closed.
awamori% ssh king-kazu
Last login: Thu Feb 19 11:23:11 2004 from ora01
Sun Microsystems Inc. SunOS 5.9 Generic May 2002
king-kazu% exit
Connection to king-kazu closed.
awamori%
awamori% which rsync
/usr/local/bin/rsync
> ホスト名：ora01,king-kazu
> /etc/hosts
> /usr/local/pgsql/data/cluster.conf
> hostnameコマンドの結果
○ ora01
----------------------------
/etc/hosts
----------------------------
ora01% more /etc/hosts
#
# Internet host table
#
127.0.0.1 localhost
192.168.1.222 ora01
#192.168.0.4 ora01
192.168.1.59 king-kazu
192.168.1.190 awamori
----------------------------
cluster.conf
----------------------------
ora01% more /usr/local/pgsql/data/cluster.conf
#============================================================
# 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
#============================================================
#------------------------------------------------------------
# set cluster DB server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Recovery_Port : connection for recovery process
#------------------------------------------------------------
<Replicate_Server_Info>
<Host_Name> awamori </Host_Name>
<Port> 8777 </Port>
<Recovery_Port> 7778 </Recovery_Port>
</Replicate_Server_Info>
#<Replicate_Server_Info>
# <Host_Name> replicate2.postgres.jp </Host_Name>
# <Port> 8777 </Port>
# <Recovery_Port> 7778 </Recovery_Port>
#</Replicate_Server_Info>
#<Replicate_Server_Info>
# <Host_Name> replicate3.postgres.jp </Host_Name>
# <Port> 8777 </Port>
# <Recovery_Port> 7778 </Recovery_Port>
#</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB server information
# o Recovery_Port : connection for recovery
# o Rsync_Path : path of rsync command
# o Rsync_Option : file transfer option for rsync
# o When_Stand_Alone : When all replication servers fell,
# you can set up two kinds of permittion,
# "real_only" or "read_write".
#-------------------------------------------------------------
<Recovery_Port> 7779 </Recovery_Port>
<Rsync_Path> /usr/local/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<When_Stand_Alone> read_only </When_Stand_Alone>
#-------------------------------------------------------------
# set 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>
----------------------------
hostname,uname -a
----------------------------
ora01% uname -a
SunOS ora01 5.8 Generic_108528-14 sun4u sparc SUNW,Sun-Blade-100
ora01% hostname
ora01
----------------------------
ssh ,rsync
----------------------------
ora01% ssh king-kazu
Last login: Thu Feb 19 10:45:10 2004 from awamori
Sun Microsystems Inc. SunOS 5.9 Generic May 2002
king-kazu%
king-kazu%
king-kazu% exit
Connection to king-kazu closed.
ora01%
ora01% ssh awamori
Last login: Thu Feb 19 11:10:23 2004 from king-kazu
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
awamori%
awamori%
awamori% exit
Connection to awamori closed.
ora01% which rsync
/usr/local/bin/rsync
○ king-kazu
----------------------------
/etc/hosts
----------------------------
king-kazu% more /etc/hosts
#
# Internet host table
#
127.0.0.1 localhost
192.168.1.59 king-kazu king-kazu.****.****.****.jp loghost ※FQDNは変更してあります．
192.168.1.222 ora01
192.168.1.190 awamori
king-kazu% more /etc/hosts | grep awamori
192.168.1.190 awamori
king-kazu% more /etc/hosts | grep ora01
192.168.1.222 ora01
king-kazu% more /etc/hosts | grep king-kazu
192.168.1.59 king-kazu king-kazu.****.****.****.****.jp loghost
----------------------------
cluster.conf
----------------------------
king-kazu% more /usr/local/pgsql/data/cluster.conf
#============================================================
# 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
#============================================================
#------------------------------------------------------------
# set cluster DB server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Recovery_Port : connection for recovery process
#------------------------------------------------------------
<Replicate_Server_Info>
<Host_Name> awamori </Host_Name>
<Port> 8777 </Port>
<Recovery_Port> 7778 </Recovery_Port>
</Replicate_Server_Info>
#<Replicate_Server_Info>
# <Host_Name> replicate2.postgres.jp </Host_Name>
# <Port> 8777 </Port>
# <Recovery_Port> 7778 </Recovery_Port>
#</Replicate_Server_Info>
#<Replicate_Server_Info>
# <Host_Name> replicate3.postgres.jp </Host_Name>
# <Port> 8777 </Port>
# <Recovery_Port> 7778 </Recovery_Port>
#</Replicate_Server_Info>
#-------------------------------------------------------------
# set Cluster DB server information
# o Recovery_Port : connection for recovery
# o Rsync_Path : path of rsync command
# o Rsync_Option : file transfer option for rsync
# o When_Stand_Alone : When all replication servers fell,
# you can set up two kinds of permittion,
# "real_only" or "read_write".
#-------------------------------------------------------------
<Recovery_Port> 7779 </Recovery_Port>
<Rsync_Path> /usr/local/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -1 </Rsync_Option>
<When_Stand_Alone> read_only </When_Stand_Alone>
#-------------------------------------------------------------
# set 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>
----------------------------
hostname,uname -a
----------------------------
king-kazu% uname -a
SunOS king-kazu 5.9 Generic sun4u sparc SUNW,Sun-Blade-100
king-kazu% hostname
king-kazu
----------------------------
ssh ,rsync
----------------------------
king-kazu% ssh ora01
Last login: Thu Feb 19 10:43:05 2004 from awamori
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
ora01%
ora01%
ora01% exit
Connection to ora01 closed.
king-kazu% ssh awamori
Last login: Thu Feb 19 10:38:24 2004 from 192.168.1.86
Sun Microsystems Inc. SunOS 5.8 Generic February 2000
awamori%
awamori% exit
Connection to awamori closed.
king-kazu%
king-kazu% which rsync
/usr/local/bin/rsync
On Thu, 19 Feb 2004 10:10:33 +0900
mitani <mitani ＠ sraw.co.jp> wrote:
> 三谷＠広島です．
>
> > webの手順に従い、pgcluster-1.0.6のインストール・設定作業を終えた後、
> > クラスタサーバにてpsqlコマンドでDBにログインしようとすると、
> > レプリケーションサーバで、大量のデバッグメッセージとゾンビプロセスが生成され、
> > うまくレプリケーションができません．
> レプリケーション要求がループしているように思います．
>
> 差し支えなければ，以下の情報を教えてください．
> ホスト名：awamori
> /etc/hosts
> /usr/local/pgsql/etc/pgreplicate.conf
> hostnameコマンドの結果
>
> ホスト名：ora01,king-kazu
> /etc/hosts
> /usr/local/pgsql/data/cluster.conf
> hostnameコマンドの結果
>
> =============================
> 三谷 篤<mitani ＠ sraw.co.jp>
> =============================
>
>
---------------------------------------
高橋 一成
pgcluster メーリングリストの案内