Amigos!
Estou implementando o pgcluster apenas para replicação --> pgreplicator.conf
Porém:
[EMAIL PROTECTED]:~$ ./bin/pgreplicate -D share/ -n -v
2008-04-25 16:16:35 [32223] DEBUG:PGR_Get_Conf_Data ok
2008-04-25 16:16:35 [32223] DEBUG:LoadBalanceTbl allocate ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():CascadeTbl shmget ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():CascadeTbl shmat ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():CascadeInf shmget ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():CascadeInf shmat ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():CommitLog shmget ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():Commit_Log_Tbl shmat ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():RLog Memory
Allocation ok
2008-04-25 16:16:35 [32223] DEBUG:registering (key,value)=(Host_Name,pg2)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(Replication_Port,8001)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(Recovery_Port,8101)
2008-04-25 16:16:35 [32223] DEBUG:registering (key,value)=(RLOG_Port,8301)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(Response_Mode,normal)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(Use_Replication_Log,no)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(Replication_Timeout,1min)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(LifeCheck_Timeout,3s)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(LifeCheck_Interval,15s)
2008-04-25 16:16:35 [32223] DEBUG:registering
(key,value)=(File_Name,/opt/pgsql/pgreplicate.log)
2008-04-25 16:16:35 [32223] DEBUG:registering (key,value)=(File_Size,1M)
2008-04-25 16:16:35 [32223] DEBUG:registering (key,value)=(Rotate,3)
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():HostTbl shmget ok
2008-04-25 16:16:35 [32223] DEBUG:PGRget_Conf_Data():HostTbl shmat ok
2008-04-25 16:16:35 [32224] DEBUG:PGRrecovery_main():PGRrecovery_main
bind port 8101
2008-04-25 16:16:35 [32223] DEBUG:replicate_main():entering replicate_main
2008-04-25 16:16:35 [32223] DEBUG:replicate_main() 8001 port bind OK
2008-04-25 16:16:35 [32223] DEBUG:cmdSts=N
2008-04-25 16:16:35 [32223] DEBUG:rlog=0
2008-04-25 16:16:35 [32223] DEBUG:port=0
2008-04-25 16:16:35 [32223] DEBUG:pid=0
2008-04-25 16:16:35 [32223] DEBUG:from_host=12.0.0.221
2008-04-25 16:16:35 [32223] DEBUG:dbName=template1
2008-04-25 16:16:35 [32223] DEBUG:userName=postgres
2008-04-25 16:16:35 [32223] DEBUG:recieve sec=0
2008-04-25 16:16:35 [32223] DEBUG:recieve usec=0
2008-04-25 16:16:35 [32223] DEBUG:query_size=60
2008-04-25 16:16:35 [32223] DEBUG:request_id=0
2008-04-25 16:16:35 [32223] DEBUG:replicate_id=0
2008-04-25 16:16:35 [32223] DEBUG:recovery_status=0
2008-04-25 16:16:35 [32223] DEBUG:query=SELECT
PGR_SYSTEM_COMMAND_FUNCTION(1,'12.0.0.221',8001,8101)
2008-04-25 16:16:35 [32223] DEBUG:PGRis_same_host():target host
2008-04-25 16:16:35 [32223] ERROR:PGRcreateConn():Retry. h_errno is
1,reason is 'could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
'
2008-04-25 16:16:35 [32223] ERROR:PGRcreateConn():Retry. h_errno is
1,reason is 'could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
'
2008-04-25 16:16:35 [32223] ERROR:PGRcreateConn():Retry. h_errno is
1,reason is 'could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
'
2008-04-25 16:16:35 [32223] ERROR:PGRcreateConn():Retry. h_errno is
1,reason is 'could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
'
2008-04-25 16:16:35 [32223] DEBUG:setTransactionTbl(): 0@ is not ready
2008-04-25 16:16:35 [32223]
ERROR:replicate_packet_send_internal():setTransactionTbl failed
--
* Juliano Souza *
Tecnologia
Grupo BEM - Emergências Médicas
PABX (11) 38716746
www.grupobem.com.br
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
