[pgcluster: 995] Re: createdb のレスポンスがない
古田 亮
furuta_ryou @ sic.co.jp
2007年 6月 27日 (水) 09:16:09 JST
三谷様
前回のメールでお伝えした設定ファイルの内容を以下に書きます。
pgreplicate.conf
#=============================================================
# PGReplicate configuration file
# for PGCluster-1.1.0a
#-------------------------------------------------------------
# file: pgreplicate.conf
#-------------------------------------------------------------
# This file controls:
# o which hosts & port are cluster server
# o which port use for replication request from cluster server
#=============================================================
#
#-------------------------------------------------------------
# A setup of Cluster DB(s)
#
# o Host_Name : The host name of Cluster DB.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Port : The connection port with postmaster.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
# o LifeCheck_Port : connection for life check process
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> kamaAP </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7101 </Recovery_Port>
<LifeCheck_Port> 7201 </LifeCheck_Port>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> kamamony </Host_Name>
<Port> 5432 </Port>
<Recovery_Port> 7121 </Recovery_Port>
<LifeCheck_Port> 7221 </LifeCheck_Port>
</Cluster_Server_Info>
#<Cluster_Server_Info>
# <Host_Name> cluster3.postgres.jp </Host_Name>
# <Port> 5432 </Port>
# <Recovery_Port> 7101 </Recovery_Port>
# <LifeCheck_Port> 7201 </LifeCheck_Port>
#</Cluster_Server_Info>
#
#-------------------------------------------------------------
# A setup of Load Balance Server
#
# o Host_Name : The host name of a load balance server.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
# o LifeCheck_Port : connection for life check process
#-------------------------------------------------------------
<LoadBalance_Server_Info>
<Host_Name> harmony </Host_Name>
<Recovery_Port> 6101 </Recovery_Port>
<LifeCheck_Port> 6201 </LifeCheck_Port>
</LoadBalance_Server_Info>
#
#------------------------------------------------------------
# A setup of the upper replication server for cascade connection.
#
# o Host_Name : The host name of Cluster DB.
# -- please write a host name by FQDN.
# -- do not write IP address.
# o Port : The connection port with postmaster.
# o Recovery_Port : The connection port at the time of
# a recovery sequence .
# o LifeCheck_Port : connection for life check process
#------------------------------------------------------------
<Replicate_Server_Info>
<Host_Name> harmony </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
<LifeCheck_Port> 8201 </LifeCheck_Port>
</Replicate_Server_Info>
#
#-------------------------------------------------------------
# A setup of a replication server
#
# o Status_Log_File : logging file of cluster db's status
# o Error_Log_File : logging file of error and warning
# o Replicate_Port : connection for reprication
# o Recovery_Port : connection for recovery
# o LifeCheck_Port : connection for life check process
# o Response_mode : timing which returns a response
# normal -- return result of DB which received the query
# reliable -- return result after waiting for response of
# all Cluster DBs.
# o Use_Replication_Log : When this server hangs up without
# being replicated to the end,
# a remote server continues the
# replication using this log.
# yes -- use replication log
# no -- not use replication log
# o Reserved_Connections : The number of reserved connections
# from this replication server
# to each cluster dbs.
# (default is 1).
#-------------------------------------------------------------
<Status_Log_File> /tmp/pgreplicate.sts </Status_Log_File>
<Error_Log_File> /tmp/pgreplicate.log </Error_Log_File>
<Replication_Port> 8001 </Replication_Port>
<Recovery_Port> 8101 </Recovery_Port>
<LifeCheck_Port> 8201 </LifeCheck_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Response_Mode> normal </Response_Mode>
<Use_Replication_Log> no </Use_Replication_Log>
<Reserved_Connections> 1 </Reserved_Connections>
pglb.conf
#============================================================
# Load Balance Server configuration file
#-------------------------------------------------------------
# file: pglb.conf
#-------------------------------------------------------------
# This file controls:
# o which hosts are db cluster server
# o which port use connect to db cluster server
# o how many connections are allowed on each DB server
#============================================================
#-------------------------------------------------------------
# set cluster DB server information
# o Host_Name : hostname
# o Port : connection for postmaster
# o Max_Connection : maximun number of connection to postmaster
#-------------------------------------------------------------
<Cluster_Server_Info>
<Host_Name> kamaAP </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 80 </Max_Connect>
</Cluster_Server_Info>
<Cluster_Server_Info>
<Host_Name> kamamony </Host_Name>
<Port> 5432 </Port>
<Max_Connect> 80 </Max_Connect>
</Cluster_Server_Info>
#<Cluster_Server_Info>
# <Host_Name> post3.postgres.jp </Host_Name>
# <Port> 5432 </Port>
# <Max_Connect> 32 </Max_Connect>
#</Cluster_Server_Info>
#-------------------------------------------------------------
# set Load Balance server information
# o Backend_Socket_Dir : Unix domain socket path for the backend
# o Receive_Port : connection from client
# o Recovery_Port : connection for recovery process
# o LifeCheck_Port : connection for life check process
# o Max_Cluster_Num : maximun number of cluster DB servers
# o Use_Connection_Pooling : use connection pool [yes/no]
# o Max_Pool_Each_Server : number of pool connections/DB server
#-------------------------------------------------------------
<Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
<Receive_Port> 5432 </Receive_Port>
<Recovery_Port> 6101 </Recovery_Port>
<LifeCheck_Port> 6201 </LifeCheck_Port>
<Max_Cluster_Num> 128 </Max_Cluster_Num>
<Use_Connection_Pooling> no </Use_Connection_Pooling>
その後、ロードバランサを使用しないことにして、
クラスタサーバを1台にして、createdbの実行を試みましたが、
やはりプロンプトが返って来ませんでした。
pgreplicateに問題があるのか、postgres自体のバージョン等の問題なのか、
全く検討がつきません。
お手数ですがご回答をいただけますようよろしくお願い致します。
以上
--
||| 古田 亮(furuta_ryou @ sic.co.jp) |
pgcluster メーリングリストの案内