Fri Feb 10 02:17:28 PST 2006
- Previous message: [Slony1-general] Clarify INSTALL?
- Next message: [Slony1-general] New in slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi im from brazil, im try to install slony on my freebsd + postgresql
8.0.3..
I have an error when i create the first node
<stdin>:30: PGRES_FATAL_ERROR select
"_pontonet".tableAddKey('public.history'); - ERROR: Slony-I: table
"public"."history" not found
-su-2.05b$
My slony2.sh is
****************
#!/bin/sh
2
3 CLUSTER=pontonet
4 DBNAME1=slonymaster
5 DBNAME2=slonyslave
6 HOST1=fileserver
7 HOST2=freebsd
8 SLONY_USER=pgsql
9 PGBENCH_USER=slony
10
11 slonik <<_EOF_
12 # ----
13 # This defines which namespace the replication system uses
14 # ----
15 cluster name = $CLUSTER;
16
17 # ----
18 # Admin conninfo's are used by the slonik program to connect
19 # to the node databases. So these are the PQconnectdb arguments
20 # that connect from the administrators workstation (where
21 # slonik is executed).
22 # ----
23 node 1 admin conninfo = 'dbname=$DBNAME1 host=$HOST1
user=$SLONY_USER';
24 node 2 admin conninfo = 'dbname=$DBNAME2 host=$HOST2
user=$SLONY_USER';
25
26 # ----
27 # Initialize the first node. The id must be 1.
28 # This creates the schema "_test1" containing all replication
29 # system specific database objects.
30 # ----
31 init cluster ( id = 1, comment = 'Node 1' );
32
33 # ----
34 # The pgbench table history does not have a primary key or
35 # any other unique constraint that could be used to identify
36 # a row. The following command adds a bigint column named
37 # "_Slony-I_test1_rowID" to the table. It will have a default
38 # value of nextval('"_test1".sl_rowid_seq'), be unique and not
39 # null. All existing rows will be initialized with a number.
40 # ----
41 table add key ( node id = 1, fully qualified name =
'public.history' );
42
43 # ----
44 # The Slony replication system organizes tables in sets. The
45 # smallest unit another node can subscribe is a set.
Usually the
46 # tables contained in one set would be all tables that have
47 # relationships to each other. The following commands create
48 # one set containing all 4 pgbench tables. The "master" or
origin
49 # of the set is node 1.
50 # ----
51 create set ( id = 1, origin = 1, comment = 'All pgbench
tables' );
52 set add table ( set id = 1, origin = 1,
53 id = 1, fully qualified name = 'public.accounts',
54 comment = 'Table accounts' );
55 set add table ( set id = 1, origin = 1,
56 id = 2, fully qualified name = 'public.branches',
57 comment = 'Table branches' );
58 set add table ( set id = 1, origin = 1,
59 id = 3, fully qualified name = 'public.tellers',
60 comment = 'Table tellers' );
61 set add table ( set id = 1, origin = 1,
62 id = 4, fully qualified name = 'public.history',
63 key = serial,
64 comment = 'Table history' );
65
66 # ----
67 # Create the second node, tell the two nodes how to connect to
68 # each other and that they should listen for events on each
69 # other. Note that these conninfo arguments are used by the
70 # slon daemon on node 1 to connect to the database of node 2
71 # and vice versa. So if the replication system is supposed to
72 # use a separate backbone network between the database servers,
73 # this is the place to tell it.
74 # ----
75 store node ( id = 2, comment = 'Node 2' );
76 store path ( server = 1, client = 2,
77 conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER');
78 store path ( server = 2, client = 1,
79 conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER');
80 store listen ( origin = 1, provider = 1, receiver = 2 );
81 store listen ( origin = 2, provider = 2, receiver = 1 );
82 _EOF_
Some people try to help me??
I have other question, this list have an historic??
Thanks Giancarlo
- Previous message: [Slony1-general] Clarify INSTALL?
- Next message: [Slony1-general] New in slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list