angga erwina <by_pacitan at yahoo.com> writes:
> hi,
> i've run slon process,then rise error messages like this..whats wrong with my setup connection..help me please...
> thanks,
> regards,
> bayu
> [postgres at laptopbps ~]$ /usr/local/pgsql/bin/slon sdki "dbname=sdki user=postgres port=5432 host=laptopbps"
> 2007-08-20 15:53:35 UTC FATAL  localListenThread: "select "_sdki".cleanupNodelock(); insert into "_sdki".sl_nodelock values (    1, 0, "pg_catalog".pg_backend_pid());
> " - ERROR:  duplicate key violates unique constraint "sl_nodelock-pkey"
> 2007-08-20 15:53:35 UTC FATAL  Do you already have a slon running against this node?
> 2007-08-20 15:53:35 UTC FATAL  Or perhaps a residual idle backend connection from a dead slon?
> 2007-08-20 15:53:35 UTC DEBUG2 slon_abort() from pid=4497

This happens when Slony-I believes there is a second slon trying to
connect to manage a node.

The error message asks the right questions.

- Do you already have a slon running against this node?
- Or perhaps a residual idle backend connection from a dead slon?
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)