Hello Guys,

I am trying to setup 2 DBs with slony on one server. Both DBs and their
behavior are completely configured on my old server. So I can take a look at
how it should "look like" using pgadmin.
I know, this might be a trivial thing, since the error message already tells
me what is wrong. But I need to know why there is no 2nd node.

cluster name = fquest

This is what I have done:
A) create DBs
    1. createdb -O $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME
    2. createdb -O $PGBENCHUSER -h $SLAVEHOST $SLAVEDBNAME
B) import structure from old server
    1. psql -d catimaster -f CATIMASTER_STRUCTURE.psql
    2. psql -d fquest -f FQUEST_STRUCTURE.psql
C) drop slony schemata on both DBs: DROP SCHEMA _fquest cascade;
D) via /etc/init.d/slony-I_fquest_master start
    1. /etc/slony-I/setup-slonik_master
    2. /etc/slony-I/setup-slon_master
E) via /etc/init.d/slony-I_fquest_slave start
    1. /etc/slony-I/setup-slonik_slave
    2. /etc/slony-I/setup-slon_slave

Then I get this message:
Starting SLONY slave(fquest) <stdin>:4: NOTICE:  subscribe set: omit_copy=f
<stdin>:4: PGRES_FATAL_ERROR select "_fquest".subscribeSet(1, 1, 2, 'f',
'f');  - ERROR:  Slony-I: subscribeSet() the receiver does not exist
receiver id:2

Using pgadmin I see that:
- DB "catimaster" lists under replication 1 cluster (fquest) correct
- but only 1 node, I think there should be 2 ("master node" and "slave node
1") I guess that is the cause for "the receiver does not exist receiver
id:2"
- further under replicationsets there are 24 tables, which is correct as
well
- but the replicationset should also contain a subscription ("slave node 1")

- DB "fquest" also lists 1 cluster
- and 2 nodes (master and slave) which seems to be correct
- there is also a replicationset but it is empty, as far as I know there
should be also 1 subscription ("slave node 1")

The scripts I am using are at pastebin:
/etc/slony-I/setup-slonik_master: http://pastebin.com/rZ2r9hnS
/etc/slony-I/setup-slon_master: http://pastebin.com/G4PHctat
/etc/slony-I/setup-slonik_slave: http://pastebin.com/gyBj349Z
/etc/slony-I/setup-slon_slave: http://pastebin.com/F5xY0GfR

I don't know why the second node is not created on the first database
(catimaster).

Further I get this error when clicking on the cluster in pgadmin:
2011-07-26 10:58:42 CEST fquest postgres ERROR:  relation "pg_listener" does
not exist at character 25
2011-07-26 10:58:42 CEST fquest postgres STATEMENT:  SELECT listenerpid FROM
pg_listener WHERE relname = '_fquest_Event'

I'd really appreciate someone looking over those scripts. Also I am not sure
about the order of execution of those scripts, but since they work well on
the old server, they shouldn't be completely wrong.

Any help is highly appreciated. I can offer some asterisk support in
exchange :)

Cheers,
Marcus


-- 
View this message in context: http://old.nabble.com/subscribeSet%28%29-the-receiver-does-not-exist-receiver-id%3A2-tp32138395p32138395.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.