Craig James craig_james at emolecules.com
Wed Apr 2 21:55:34 PDT 2008
I keep getting this error:

   remoteListenThread_1: db_getLocalNodeId() returned 2 - wrong database?

I suspect the slon daemon can't handle port numbers correctly.  In this case, both the master and slave databases have the same name, AND the same host.  The only difference is the port number.

When I start slon, it seems to try to figure out the node number from the combination of dbname+host, but it seems to ignore the port number, so it arbitrarily will get node 1 or node 2.

(In case you're wondering, the second database is actually on a different machine, accessed via an encrypted ssh(1) tunnel that maps port 5433 on the local machine to port 5432 on the remote machine.  So the two databases are accessed by the same name and same host, with only the port to distinguish them.)

Is my analysis correct?  How does the slon daemon figure out which node number it is working on?  There doesn't seem to be any way to tell it.

Thanks,
Craig


More information about the Slony1-general mailing list