Sat Aug 21 19:07:27 PDT 2004
- Previous message: [Slony1-general] Issue
- Next message: [Slony1-general] configuration hiccup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
when running slonik with the following input file: cluster name = pcireload_cluster; node 1 admin conninfo = 'dbname=pcireload host=192.168.46.12 user=postgres'; node 2 admin conninfo = 'dbname=pcireload_slave host=192.168.46.6 user=postgres'; init cluster ( id=1, comment = 'Master Node'); table add key (node id = 1, fully qualified name = 'public.history'); create set (id=1, origin=1, comment='All pgbench tables'); set add table (set id=1, origin=1, id=1, fully qualified name = 'public.accounts', comment='accounts table'); set add table (set id=1, origin=1, id=2, fully qualified name = 'public.branches', comment='branches table'); set add table (set id=1, origin=1, id=3, fully qualified name = 'public.tellers', comment='tellers table'); set add table (set id=1, origin=1, id=4, fully qualified name = 'public.history', comment='history table', key = serial); store node (id=2, comment = 'Slave node'); store path (server = 1, client = 2, conninfo='dbname=pcireload host=192.168.46.12 user=postgres'); store path (server = 2, client = 1, conninfo='dbname=pcireload_slave host=192.168.46.6 user=postgres'); store listen (origin=1, provider = 1, receiver =2); store listen (origin=2, provider = 2, receiver =1); i receive the following error message: replication_config.in:5: PGRES_FATAL_ERROR select "_pcireload_cluster".tableAddKey('public.history'); - ERROR: Slony-I: table public.history not found NEWBIE question: is "public.history" a table that slonik was supposed to set up to keep track of replication stuff, or is it to be replaced in this example from the dox, along with the other three tables listed there (accounts, branches, teller) with the actual table names from MY database? much thanks, -robin p.s. - in the dox "slony-I-basic-mstr-slv.txt from" the tarball i downloaded yesterday, there is at least one syntax error with the first script transcribed; the lines that begin with node 1 admin conninfo 'dbname=... node 2 admin conninfo 'dbname=... should read node 1 admin conninfo = 'dbname=... node 2 admin conninfo = 'dbname=...
- Previous message: [Slony1-general] Issue
- Next message: [Slony1-general] configuration hiccup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list