Hi guys,

gotta ask here for advice, after asking on IRC. My college told me he set up
slony on an existing DB. Now I am trying to copy 2 DBs from our old server
to new hardware. I already imported the globals, the structure and the data
from the old server. Is it even possible to get slony working on this new
machine now?
replication is local between to DBs for now. slony won't work:

fquest-b1:/etc/slony-I # /etc/init.d/slony-I_fquest_master start
fquest-b1:/etc/slony-I # cat  /var/log/slony-I/master_fquest.log
-->...
-->2011-07-08 16:57:57 CESTERROR  Slony-I schema version is 2.0.5
-->2011-07-08 16:57:57 CESTERROR  please upgrade Slony-I schema to version
2.0.6
-->...

/etc/slony-I/slonik < upgradeslony
<stdin>:6: PGRES_FATAL_ERROR select
"_catimaster".getLocalNodeId('_catimaster'); - ERROR:  schema "_catimaster"
does not exist
<stdin>:6: database specified in <stdin>:4 reports no_id -1


then I started again looking at the tutorial (2.1.2. Preparing the
Databases) and thought the following might help...:
"createdb -O $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME"

but of course it leads to the following error:
-->ERROR:  database "catimaster" already exists

yes, it exists...

what now, do I really have to start from scratch? I kind IRC user in #slony
told me this is the way to go:
...
a) you have to drop slony schema from server B ( thats of no use )
b) create another db, where you will replicate on the same server in your
case
c) install slony from scratch..
d) init db

and ya... after init node.. you would need to do create set and set add
table too..

e) store node
f) store path
g) start the slons and subscribe

schema you get from pg_dump is of no use...
when you do init node ... it will get created again..
...

Any help is highly appreciated, since I am new to slony. Thanks a lot in
advance.

Cheers,
Marcus

-- 
View this message in context: http://old.nabble.com/Is-it-possible-to-add-slony-to-an-existing-DB-%28imported-from-old-slony-server%29--tp32092506p32092506.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.