In the first message I forgot to put another log:
2006-09-14 18:41:44 [12395] ERROR:  duplicate key violates unique constraint
"trusted_chave_key"


 Below there is the original message:

---------- Forwarded message ----------
From: Andrew And <andcop2006 at gmail.com>
Date: 15/09/2006 23:11
Subject: Slony stop after 9 hours
To: Slony1-general at gborg.postgresql.org



 After some time my SLONY master stop to  replicate table, and SLAVE don?t
receive new datas.

 In syslog file /var/log/postgresql/postgres.log I have:
1- When slony is ok:
2006-09-15 11:06:55 [1967] LOG:  connection received: host=X.Y.Z.W port=1032
2006-09-15 11:06:55 [1967] LOG:  connection authorized: user=postgres
database=trusted

2 - After 9 hours slony stop:
2006-09-15 20:03:54 [4006] LOG:  connection received: host=[local] port=
2006-09-15 20:03:54 [4006] LOG:  connection authorized: user=postgres
database=trusted
 In (2) I use "ps -aux" and the output show me that SLONY is not down.


 I am thinking that SLONY lost information about host and port after 9
hours. In this situationI need to restart Slony in maste, butitis not good.

 What can I do in this situation?   What variables do I need to use? and
where should I put the variables?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060915/da9e98e2/attachment.html