Delete the _EOF_ at the end of the script.

-----Mensaje original----- 
From: NewToSlony
Sent: Monday, February 20, 2012 10:45 AM
To: slony1-general at lists.slony.info
Subject: [Slony1-general] Syntax error?


Hi,

I'm trying to use the example in the 2.1.1 documentation but I keep getting
a syntax error.  I've noted that the doc shows
cluster name = $CLUSTERNAME;
is a valid syntax but unless I change the $ to a @ I get a syntax error,
thus as I'm new and unsure I don't know if there are errors in the
documentation or something I am missing.  Never the less, my script as as
follows:


#!/bin/sh

CLUSTERNAME= slony_example;
/opt/local/lib/postgresql90/bin/slonik <<_EOL_
define CLUSTERNAME slony_example;
cluster name = @CLUSTERNAME;
node 1 admin conninfo = 'dbname=my_primary host=localhost user=user';
node 2 admin conninfo = 'dbname=my_rep host=localhost user=user';
#-- 
# 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');
#--
# 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.pgbench_accounts', comment='accounts table');
set add table (set id=1, origin=1, id=2, fully qualified
name='public.pgbench_branches', comment='branches table');
set add table (set id=1, origin=1, id=3, fully qualified
name='public.pgbench_tellers', comment='tellers table');
set add table (set id=1, origin=1, id=4, fully qualified
name='public.pgbench_history', comment='history table');
#-- 
# Create the second node (the slave) tell the 2 nodes how to connect to
Slony-I 2.1.1 Documentation 10 / 163
# each other and how they should listen for events.
#--
store node (id=2, comment = 'Slave node', event node=1);
store path (server = 1, client = 2, conninfo='dbname=my_primary
host=localhost user=user');
store path (server = 2, client = 1, conninfo='dbname=my_rep host=localhost
user=user');
_EOF_


Yet I get the following syntax error:


/tmp/slonik_example.sh: line 3: slony_example: command not found
<stdin>:24: ERROR: syntax error at or near _EOF_

-- 
View this message in context: 
http://old.nabble.com/Syntax-error--tp33357837p33357837.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general