Michael Vodep mvodep
Thu Apr 27 01:55:49 PDT 2006
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




More information about the Slony1-general mailing list