[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 メーリングリストの案内