Fri Mar 6 05:19:16 PST 2009
- Previous message: [Slony1-general] successfully added a field to a replicated database
- Next message: [Slony1-general] Some small errors in the documentation
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Dear list,
just getting started with Slony 2.0.1 and going through the
documentation, so I found some small errors in the chapter "2.
Replicating Your First Database":
1. The line:
psql -U $PGBENCH_USER -h $HOST1 -d $DBNAME1 -c "begin; alter table
history add column id serial; update history set id =
nextval('history_id_seq'); alter table history add primary key(id);
commit"
should rather be:
sql -U $PGBENCHUSER -h $MASTERHOST -d $MASTERDBNAME -c "begin; alter
table
history add column id serial; update history set id =
nextval('history_id_seq'); alter table history add primary key(id);
commit"
2. In the slonik script, this section should be removed since 2.0 no
longer uses "table add key":
#--
# Because the history table does not have a primary key or other unique
# constraint that could be used to identify a row, we need to add one.
# The following command adds a bigint column named
# _Slony-I_$CLUSTERNAME_rowID to the table. It will have a default
value
# of nextval('_$CLUSTERNAME.s1_rowid_seq'), and have UNIQUE and NOT
NULL
# constraints applied. All existing rows will be initialized with a
# number
#--
table add key (node id = 1, fully qualified name = 'public.history');
Hope this helps to keep the docu up to date ;.-)
All the best
Bastian
- Previous message: [Slony1-general] successfully added a field to a replicated database
- Next message: [Slony1-general] Some small errors in the documentation
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list