On 10/28/2010 6:15 AM, Jason Chen wrote:
> Hi,
>
> When I tried to deploy slony-2.0.4, there have a problem I met during
> slave node configuration. Maser node slon process looks hang and there
> is *<event pending>* in pa_conninfo of sl_path table. Below is the
> output of that table.
>
> [root at slony-r1s1-001 ~]# psql -U postgres system.db -c "select * from
> _slony.sl_path"
>   pa_server | pa_client |
> pa_conninfo                                       | pa_connretry
> -----------+-----------+-----------------------------------------------------------------------------+--------------
> 2 |         1 | host=192.168.11.12 dbname=system.db user=postgres
> port=5432|           10
> 1 |         2 | <event
> pending>
> |           10

Is the conninfo for pa_server=2 and pa_client=1 correct?

Is the port 5432 on host 192.168.11.12 actually reachable (firewall)?


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin