Thu Apr 27 01:55:49 PDT 2006
- Previous message: [Slony1-general] Make question
- Next message: [Slony1-general] Slony with PGSQL 8
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Make question
- Next message: [Slony1-general] Slony with PGSQL 8
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list