I'm using slony 2.2.2 to migrate from 8.4 to 9.3 and after the initial sync has completed, I'm seeing the following in the slon logs on the subscriber (node 2):

2014-02-16 02:01:19 UTC ERROR  remoteListenThread_2: db_getLocalNodeId() returned 1 - wrong database?

And indeed, if I run this query on the subscriber:

select "_migration".getlocalnodeid('_migration');
getlocalnodeid
----------------
             1
(1 row)

Except it should be node 2.

Is there anyway to fix this without a full resync?

Do I need to revert to 2.2.1 and resync?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 208 bytes
Desc: Message signed with OpenPGP using GPGMail
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20140215/4473747c/attachment.pgp