Hi,

i'm building a setup for a database replication one master one client.

I've not figured out really works. I changed the sampe from the install
guide to fi my DB.

And it seems to work. I have synced data on the client.

But:
I get this error on the client

tilli at tilmanb:~$ slon licenseserver_cluster "dbname=licenseserver
user=licenseserver host=localhost"
2006-08-16 13:34:19 CEST CONFIG main: slon version 1.1.5 starting up
2006-08-16 13:34:19 CEST CONFIG main: local node id = 2
2006-08-16 13:34:19 CEST CONFIG main: launching sched_start_mainloop
2006-08-16 13:34:19 CEST CONFIG main: loading current cluster configuration
2006-08-16 13:34:19 CEST CONFIG storeNode: no_id=1 no_comment='Master Node'
2006-08-16 13:34:19 CEST CONFIG storePath: pa_server=1 pa_client=2
pa_conninfo="dbname=licenseserver host=localhost user=licenseserver"
pa_connretry=10
2006-08-16 13:34:19 CEST CONFIG storeListen: li_origin=1 li_receiver=2
li_provider=1
2006-08-16 13:34:19 CEST CONFIG storeSet: set_id=1 set_origin=1
set_comment='Portal tables'
2006-08-16 13:34:19 CEST WARN   remoteWorker_wakeup: node 1 - no worker
thread
2006-08-16 13:34:19 CEST CONFIG main: configuration complete - starting
threads
2006-08-16 13:34:19 CEST DEBUG1 localListenThread: thread starts
2006-08-16 13:34:21 CEST CONFIG enableNode: no_id=1
2006-08-16 13:34:21 CEST DEBUG1 main: running scheduler mainloop
2006-08-16 13:34:21 CEST DEBUG1 remoteWorkerThread_1: thread starts
2006-08-16 13:34:21 CEST DEBUG1 remoteListenThread_1: thread starts
2006-08-16 13:34:21 CEST DEBUG1 cleanupThread: thread starts
2006-08-16 13:34:21 CEST DEBUG1 syncThread: thread starts
2006-08-16 13:34:21 CEST ERROR  remoteListenThread_1:
db_getLocalNodeId() returned 2 - wrong database?
2006-08-16 13:34:33 CEST ERROR  remoteListenThread_1:
db_getLocalNodeId() returned 2 - wrong database?
2006-08-16 13:34:44 CEST ERROR  remoteListenThread_1:
db_getLocalNodeId() returned 2 - wrong database?

The last line repeating over and over.
No idea what this is about. Looks not good. :)


The next thing i'm nost sure of is in which direction i need tcp connect
to the db.
I would prefer if the client must not be able to connect to the master.
Would this work?
Can i push the data from the master or do they have cross-connections?


What i found anoying while seting it up was that i could not init a
cluster with the same name after it failed the first time.
Is there a nice way to whipe half initialized cluster definitions?

And a note that you need superuser permissions on the tb and a note how
to use .pgpass would be usefull.


-- 
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Strasse 60 . 79111 Freiburg . Germany

p: +49 (0) 89-990157-0
f: +49 (0) 89-990157-11