Hi everyone,
I am very close to having replication work but I am running into a
problem now. Both my configuration and replication scripts run without
error. When I run my configuration script, the _newschema is created in
both the master and slave databases with all the slony default tables.
The replication set is also created on both machines except there is one
difference. On the master, under replication set--->nodes, both the
master and slave contain 1 path and 1 listen. On the slave machine, the
master node doesn't contain any paths or listens and there are 0
subscriptions and the table is not replicated over. All connection
information is correct.
I was wondering if there is a problem in my scripts that is preventing
the subscription (and table replication) to the slave node. Here are my
two scripts. ANY help at all would be greatly appreciated!! Thanks!!
Configuration Script
cluster name =public;
node 1 admin conninfo = 'dbname=xxx host=yyy user=zzz password=xyz';
node 2 admin conninfo = 'dbname=xxx host=zzz user=yyy
password=zyx';
init cluster ( id=1, comment = 'Master Node');
create set (id=1, origin=1, comment='All pbih_slon tables');
set add table (set id=1, origin=1, id=1, fully qualified name =
'public.eric',
comment='eric table');
store node (id=2, comment = 'Slave node');
store path (server = 1, client = 2,
conninfo = 'dbname=xxx host=yyy user=zzz password=xyz);
store path (server = 2, client = 1,
conninfo = 'dbname=xxx host=zzz user=yyy password=zyx');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
Replication Script
CLUSTER NAME =public;
node 1 admin conninfo = 'dbname=xxx host=yyy user=zzz
password=xyz';
node 2 admin conninfo = 'dbname=xxx host=zzz user=yyy
password=zyx';
SUBSCRIBE SET (
ID = 1,
PROVIDER = 1,
RECEIVER = 2,
FORWARD = YES
);
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
