I make 2 physical hosts, 2x(postgresql + pgreplicate) on FreeBSD 7.0 replicate funcation is successful. same configuration on FreeBSD 7.1, replicate funcation is unsuccessful.
1. debug on FreeBSD 7.1: %pgreplicate -D data -nv 2009-02-01 21:47:48 [739] DEBUG:PGR_Get_Conf_Data ok 2009-02-01 21:47:48 [739] DEBUG:LoadBalanceTbl allocate ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():CascadeTbl shmget ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():CascadeTbl shmat ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():CascadeInf shmget ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():CascadeInf shmat ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():CommitLog shmget ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():Commit_Log_Tbl shmat ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():RLog Memory Allocation ok 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Host_Name,cluster8) 2009-02-01 21:47:48 [739] DEBUG:registering hostname cluster8 2009-02-01 21:47:48 [739] DEBUG:resolved name is 192.168.2.78 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Port,5432) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Recovery_Port,7001) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Host_Name,cluster9) 2009-02-01 21:47:48 [739] DEBUG:registering hostname cluster9 2009-02-01 21:47:48 [739] DEBUG:resolved name is 192.168.2.79 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Port,5432) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Recovery_Port,7001) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Host_Name,cluster9) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Replication_Port,8001) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Recovery_Port,8101) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(RLOG_Port,8301) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Response_Mode,normal) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Use_Replication_Log,no) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Replication_Timeout,1min) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(LifeCheck_Timeout,3s) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(LifeCheck_Interval,15s) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(File_Name,pgreplicate.log) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(File_Size,1M) 2009-02-01 21:47:48 [739] DEBUG:registering (key,value)=(Rotate,3) 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():HostTbl shmget ok 2009-02-01 21:47:48 [739] DEBUG:PGRget_Conf_Data():HostTbl shmat ok 2009-02-01 21:47:48 [739] DEBUG:replicate_main():entering replicate_main 2009-02-01 21:47:48 [740] DEBUG:PGRrecovery_main():PGRrecovery_main bind port 8101 2009-02-01 21:47:48 [739] DEBUG:replicate_main() 8001 port bind OK 2009-02-01 21:47:48 [739] DEBUG:cmdSts=N 2009-02-01 21:47:48 [739] DEBUG:rlog=0 2009-02-01 21:47:48 [739] DEBUG:port=0 2009-02-01 21:47:48 [739] DEBUG:pid=0 2009-02-01 21:47:48 [739] DEBUG:from_host=192.168.2.79 2009-02-01 21:47:48 [739] DEBUG:dbName=template1 2009-02-01 21:47:48 [739] DEBUG:userName=pgsql 2009-02-01 21:47:48 [739] DEBUG:recieve sec=0 2009-02-01 21:47:48 [739] DEBUG:recieve usec=0 2009-02-01 21:47:48 [739] DEBUG:query_size=62 2009-02-01 21:47:48 [739] DEBUG:request_id=0 2009-02-01 21:47:48 [739] DEBUG:replicate_id=0 2009-02-01 21:47:48 [739] DEBUG:recovery_status=0 2009-02-01 21:47:48 [739] DEBUG:query=SELECT PGR_SYSTEM_COMMAND_FUNCTION (1,'192.168.2.79',8001,8101) 2009-02-01 21:47:48 [739] DEBUG:PGRis_same_host():target host the data/pgreplicate.sts say: Sun Feb 1 21:47:48 2009 port(5432) host:cluster8 initialize Sun Feb 1 21:47:48 2009 port(5432) host:cluster9 initialize Sun Feb 1 21:47:48 2009 cascade(192.168.2.79) port(8001) start use 2. debug on FreeBSD 7.0 %pgreplicate -D data -nv 2009-02-01 22:15:20 [735] DEBUG:PGR_Get_Conf_Data ok 2009-02-01 22:15:20 [735] DEBUG:LoadBalanceTbl allocate ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():CascadeTbl shmget ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():CascadeTbl shmat ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():CascadeInf shmget ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():CascadeInf shmat ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():CommitLog shmget ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():Commit_Log_Tbl shmat ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():RLog Memory Allocation ok 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Host_Name,cluster6) 2009-02-01 22:15:20 [735] DEBUG:registering hostname cluster6 2009-02-01 22:15:20 [735] DEBUG:resolved name is 192.168.2.76 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Port,5432) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Recovery_Port,7001) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Host_Name,cluster7) 2009-02-01 22:15:20 [735] DEBUG:registering hostname cluster7 2009-02-01 22:15:20 [735] DEBUG:resolved name is 192.168.2.77 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Port,5432) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Recovery_Port,7001) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Host_Name,cluster6) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Replication_Port,8001) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Recovery_Port,8101) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(RLOG_Port,8301) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Response_Mode,normal) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Use_Replication_Log,no) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Replication_Timeout,1min) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(LifeCheck_Timeout,3s) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(LifeCheck_Interval,15s) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(File_Name,pgreplicate.log) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(File_Size,1M) 2009-02-01 22:15:20 [735] DEBUG:registering (key,value)=(Rotate,3) 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():HostTbl shmget ok 2009-02-01 22:15:20 [735] DEBUG:PGRget_Conf_Data():HostTbl shmat ok 2009-02-01 22:15:20 [735] DEBUG:replicate_main():entering replicate_main 2009-02-01 22:15:20 [736] DEBUG:PGRrecovery_main():PGRrecovery_main bind port 8101 2009-02-01 22:15:20 [735] DEBUG:replicate_main() 8001 port bind OK 2009-02-01 22:15:20 [735] DEBUG:cmdSts=N 2009-02-01 22:15:20 [735] DEBUG:rlog=0 2009-02-01 22:15:20 [735] DEBUG:port=0 2009-02-01 22:15:20 [735] DEBUG:pid=0 2009-02-01 22:15:20 [735] DEBUG:from_host=192.168.2.76 2009-02-01 22:15:20 [735] DEBUG:dbName=template1 2009-02-01 22:15:20 [735] DEBUG:userName=pgsql 2009-02-01 22:15:20 [735] DEBUG:recieve sec=0 2009-02-01 22:15:20 [735] DEBUG:recieve usec=0 2009-02-01 22:15:20 [735] DEBUG:query_size=62 2009-02-01 22:15:20 [735] DEBUG:request_id=0 2009-02-01 22:15:20 [735] DEBUG:replicate_id=0 2009-02-01 22:15:20 [735] DEBUG:recovery_status=0 2009-02-01 22:15:20 [735] DEBUG:query=SELECT PGR_SYSTEM_COMMAND_FUNCTION (1,'192.168.2.76',8001,8101) 2009-02-01 22:15:20 [735] DEBUG:PGRis_same_host():target host 2009-02-01 22:15:20 [735] DEBUG:PGRis_same_host():target host 2009-02-01 22:15:20 [735] DEBUG:start thread_send_cluster() 2009-02-01 22:15:20 [735] DEBUG:send_replicate_packet_to_server():PQexec send :SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'192.168.2.76',8001,8101) 2009-02-01 22:15:20 [735] DEBUG:send_replicate_packet_to_server():PQexec returns :SYSTEM_COMMAND 2009-02-01 22:15:20 [735] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0 2009-02-01 22:15:20 [735] DEBUG:thread_send_cluster():pthread_exit[0] 2009-02-01 22:15:21 [735] DEBUG:start thread_send_cluster() 2009-02-01 22:15:21 [735] DEBUG:send_replicate_packet_to_server():PQexec send :SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'192.168.2.76',8001,8101) 2009-02-01 22:15:21 [735] DEBUG:send_replicate_packet_to_server():PQexec returns :SYSTEM_COMMAND 2009-02-01 22:15:21 [735] DEBUG:thread_send_cluster():return value from send_replicate_packet_to_server() is 0 2009-02-01 22:15:21 [735] DEBUG:thread_send_cluster():pthread_exit[1] the data/pgreplicate.sts say: Sun Feb 1 22:15:20 2009 port(5432) host:cluster6 initialize Sun Feb 1 22:15:20 2009 port(5432) host:cluster7 initialize Sun Feb 1 22:15:20 2009 cascade(192.168.2.76) port(8001) start use Sun Feb 1 22:15:20 2009 port(5432) host:cluster6 start use Sun Feb 1 22:15:21 2009 port(5432) host:cluster7 start use _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
