Hi!
I am running the latest Slony Release with PostgreSQL 8. I'm not
quite sure if my slonik scripts are correct - especially the
subscriber sections:
Following script i executed on the Master Host:
========================================================================
================
#!/bin/sh
slonik <<_EOF_
cluster name = bsc;
node 1 admin conninfo = 'dbname=bs_master host=192.168.1.222
user=pgsql';
node 2 admin conninfo = 'dbname=bs_slave host=192.168.1.220
port=5433 user=pgsql';
node 3 admin conninfo = 'dbname=bs_slave host=192.168.1.221
port=5434 user=pgsql';
init cluster ( id=1, comment = 'Master Node');
create set (id=1, origin=1, comment='All bs tables');
set add table (set id=1, origin=1, id=1, fully qualified name =
'public.t_books', comment='book table');
store node (id=2, comment = 'Slave node 1');
store node (id=3, comment = 'Slave node 2');
store path (server = 1, client = 2, conninfo='dbname=bs_master
host=192.168.1.222 user=pgsql');
store path (server = 2, client = 1, conninfo='dbname=bs_slave
host=192.168.1.220 port=5433 user=pgsql');
store path (server = 1, client = 3, conninfo='dbname=bs_master
host=192.168.1.222 user=pgsql');
store path (server = 3, client = 1, conninfo='dbname=bs_slave
host=192.168.1.221 port=5434 user=pgsql');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
store listen (origin=3, provider = 3, receiver =1);
_EOF_
========================================================================
================
This script is for my 2 slaves machines:
========================================================================
================
#!/bin/sh
slonik <<_EOF_
cluster name = bsc;
node 1 admin conninfo = 'dbname=bs_master host=192.168.1.222
user=pgsql';
node 2 admin conninfo = 'dbname=bs_slave host=192.168.1.220
port=5433 user=pgsql';
node 3 admin conninfo = 'dbname=bs_slave host=192.168.1.221
port=5434 user=pgsql';
subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);
subscribe set ( id = 1, provider = 1, receiver = 3, forward = no);
_EOF_
========================================================================
================
The replication works as expected - if i execute a INSERT or UPDATE
statement on the master - the 2 slaves also have the same data as the
master has.
Is there something i can improve?
Thanks,
Best regards
michael
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
