Fernando Schapachnik fernando
Wed Mar 9 15:45:05 PST 2005
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}.

	Thanks in advance.


Fernando.


More information about the Slony1-general mailing list