bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Tue Oct 18 02:25:20 PDT 2011
http://www.slony.info/bugzilla/show_bug.cgi?id=245

           Summary: slony tutorial + new feature (set add table with a
                    regexp) does not work
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: low
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cedric.villemain.debian at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


based on the tutorial.

/usr/lib/postgresql/9.1/bin/slonik < create_set.slonik
<stdin>:8: waiting for event (1,5000000011) to be confirmed on node 2

same output for (very) long time, I have to kill slonik

preamble.slonik
    cluster name = slony;
    node 1 admin conninfo = 'dbname=slony_bench host=192.168.100.165
user=replicator';
    node 2 admin conninfo = 'dbname=slony_bench host=192.168.100.237
user=replicator';
    node 3 admin conninfo = 'dbname=slony_bench host=192.168.122.111
user=replicator';
    node 4 admin conninfo = 'dbname=slony_bench host=192.168.122.22
user=replicator';

create_set.slonik
include </tmp/preamble.slonik>;
init cluster (id = 1);
create set (id = 1, origin = 1);
set add table (set id=1, tables='public\\.*');

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

store path (server = 1, client = 2, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');
store path (server = 1, client = 3, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');
store path (server = 1, client = 4, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');

store path (server = 2, client = 1, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');
store path (server = 2, client = 3, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');
store path (server = 2, client = 4, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');

store path (server = 3, client = 1, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');
store path (server = 3, client = 2, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');
store path (server = 3, client = 4, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');

store path (server = 4, client = 1, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');
store path (server = 4, client = 2, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');
store path (server = 4, client = 3, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.


More information about the Slony1-bugs mailing list