Ola!Talvez alguem no forum tenha ideia do que sejaEncontrei um material na internet explicando como configurar o slony, segui o passo a passo, porem quando vou rodar o comando no servidor secundario, este comando abaixo: slon sql_cluster "dbname=bd_replica host=192.168.1.254 user=postgres"Ele da um erro de duplicate key. conforme abaixo.Você tem ideia do que possa ser?Desde ja agradeço2010-05-10 19:05:44 BRTCONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=bd_replica host=192.168.10.10 user=postgres" pa_connretry=10 2010-05-10 19:05:44 BRTCONFIG storeListen: li_origin=2 li_receiver=1 li_provider=22010-05-10 19:05:44 BRTCONFIG storeSet: set_id=1 set_origin=1 set_comment='objetos replicados'2010-05-10 19:05:44 BRTCONFIG main: last local event sequence = 5000000010 2010-05-10 19:05:44 BRTCONFIG main: configuration complete - starting threads2010-05-10 19:05:44 BRTINFO localListenThread: thread starts2010-05-10 19:05:45 BRTCONFIG version for "dbname=bd_replica host=192.168.1.254 user=postgres" is 80403 2010-05-10 19:05:46 BRTFATAL localListenThread: "select "_sql_cluster".cleanupNodelock(); insert into "_sql_cluster".sl_nodelock values ( 1, 0, "pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey" 2010-05-10 19:05:46 BRTINFO slon: shutdown requested2010-05-10 19:05:46 BRTINFO slon: notify worker process to shutdown2010-05-10 19:06:06 BRTINFO slon: child termination timeout - kill child2010-05-10 19:06:06 BRTCONFIG slon: child terminated status: 9; pid: 858, current worker pid: 858 2010-05-10 19:06:06 BRTINFO slon: done2010-05-10 19:06:06 BRTINFO slon: exit(0)
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
