Fernando Schapachnik wrote:

>Hi,
>	I'm trying to setup slony replication between to host, following the 
>basic howto.
>
>	At one point, I start slon on both machines.
>
>On master:
>slon -d 2 $CLUSTERNAME "dbname=$MASTERDBNAME user=$REPLICATIONUSER 
>host=$MASTERHOST"
>
>On slave:
>
>slon -d 2 $CLUSTERNAME "dbname=$SLAVEDBNAME user=$REPLICATIONUSER 
>host=$SLAVEHOST"
>
>	Here is the output from the slave:
>
>CONFIG main: slon version 1.0.5 starting up
>CONFIG main: local node id = 1
>CONFIG main: loading current cluster configuration
>CONFIG storeNode: no_id=2 no_comment='SLAVE node'
>DEBUG2 setNodeLastEvent: no_id=2 event_seq=7
>CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=mydb 
>host=slavehost user=slony" pa_connretry=10
>CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
>CONFIG storeSet: set_id=1 set_origin=1 set_comment='XXXX'
>DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled)
>DEBUG2 main: last local event sequence = 151
>CONFIG main: configuration complete - starting threads
>DEBUG1 localListenThread: thread starts
>CONFIG enableNode: no_id=2
>DEBUG1 main: running scheduler mainloop
>DEBUG1 remoteWorkerThread_2: thread starts
>DEBUG1 remoteListenThread_2: thread starts
>DEBUG1 syncThread: thread starts
>DEBUG1 cleanupThread: thread starts
>DEBUG2 remoteListenThread_2: start listening for event origin 2
>ERROR  remoteListenThread_2: db_getLocalNodeId() returned 1 - wrong database?
>
>	Note the "local node id = 1". Any idea? Both are FreeBSD 5.3+Postgres 
>7.3.{8,9}.
>  
>
My suspicion is that there's some confusion taking place as to which 
host is which.

Try logging in using the DSN (e.g. - dbname=mydb host=slavehost 
user=slony) and see what you get...

Is it possible that DNS resolution is messing up somehow, that 
"slavehost" is pointing to the wrong server?