<stdin>:5: ERROR: syntax error at or near Try
Will someone please enlighten me on what im doin wrong ?
Thanks,
Sujin Philip
#!/bin/sh
slonik <<_EOF_
#--
# define the namespace the replication system uses in our example it is
# slony_example
#--
cluster name = $CLUSTERNAME;
#--
# admin conninfo's are used by slonik to connect to the nodes one for each
# node on each side of the cluster, the syntax is that of PQconnectdb in
# the C-API
# --
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER';
#--
# init the first node. Its id MUST be 1. This creates the schema
# _$CLUSTERNAME containing all replication system specific database
# objects.
#--
init cluster ( id=1, comment = 'Master Node');
#--
# 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');
#--
# Slony-I organizes tables into sets. The smallest unit a node can
# subscribe is a set. The following commands create one set containing
# all 4 pgbench tables. The master or origin of the set is node 1.
#--
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);
#--
# Create the second node (the slave) tell the 2 nodes how to connect to
# each other and how they should listen for events.
#--
store node (id=2, comment = 'Slave node');
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER');
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
_EOF_
On 3/6/06, Christopher Browne <[EMAIL PROTECTED]
> wrote:
john joe wrote:
> bash-3.00$ slonik <<_EOF_
> > try {
> > echo 'test';
> > }
> > on error {
> > echo 'fail';
> > }
> > _EOF_
> <stdin>:1: ERROR: syntax error at or near try
>
> It seems like whatever i try running with slonik has a syntax error on
> the first line of the script .
> Im using FC4 with following packages.
>
> postgresql-libs-8.0.6-1PGDG
> postgresql-devel-8.0.6-1PGDG
> postgresql-8.0.5-1PGDG
> postgresql-slony1-engine-1.1.5-1_PG8.1.2
> postgresql-server-8.0.5-1PGDG
>
> Can anyone help me ?
> Thanks in advance.
> Sujin Philip
Every slonik script must begin with a "preamble" that does two things:
1. Names the cluster
2. Defines paths to let slonik know how to talk to the nodes in the cluster
http://linuxfinances.info/info/hdrcmds.html
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
