On 11-07-26 05:01 AM, marmu wrote:
>
> 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

You need to add something like

store node(id=2, event node=1);

before the subscribe set command in your
fquest-slave-setupmaker script


>
> 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'

This error is unrelated, but might be because the version of pgadmin you 
have is older than the version of postgresql you are using.

I will also warn you that many (maybe even the last released one) 
versions of pgadmin don't properly work with slony 2.0.x



>
> 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
>
>