Andrew And andcop2006
Fri Sep 15 19:11:56 PDT 2006
 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/8e3fe08a/attachment.html 



More information about the Slony1-general mailing list