Robin Walker robin
Sat Aug 21 19:07:27 PDT 2004
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=...


More information about the Slony1-general mailing list