Hi Jan,<br><br>Thanks for your response. conninfo information is correct and also port 5432 on host 192.168.11.12 is reachable without firewall. <br><br>Best regards,<br>Jason<br><br><div class="gmail_quote">On Thu, Oct 28, 2010 at 10:27 PM, Jan Wieck <span dir="ltr"><<a href="mailto:JanWieck@yahoo.com">JanWieck@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On 10/28/2010 6:15 AM, Jason Chen wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br>
<br>
When I tried to deploy slony-2.0.4, there have a problem I met during<br>
slave node configuration. Maser node slon process looks hang and there<br>
is *<event pending>* in pa_conninfo of sl_path table. Below is the<br>
output of that table.<br>
<br>
[root@slony-r1s1-001 ~]# psql -U postgres system.db -c "select * from<br>
_slony.sl_path"<br>
pa_server | pa_client |<br>
pa_conninfo | pa_connretry<br>
-----------+-----------+-----------------------------------------------------------------------------+--------------<br>
2 | 1 | host=192.168.11.12 dbname=system.db user=postgres<br>
port=5432| 10<br>
1 | 2 | <event<br>
pending><br>
| 10<br>
</blockquote>
<br></div>
Is the conninfo for pa_server=2 and pa_client=1 correct?<br>
<br>
Is the port 5432 on host 192.168.11.12 actually reachable (firewall)?<br>
<br>
<br>
Jan<br><font color="#888888">
<br>
-- <br>
Anyone who trades liberty for security deserves neither<br>
liberty nor security. -- Benjamin Franklin<br>
</font></blockquote></div><br>