lio bod a écrit :
> Hello world,
>  
> Still having fun with supplied shell scripts :
>  
> After setting env variales, i made work configure-replication.sh
>  
>>/tmp/slonytest-temp.Q17311/create_set.slonik
>>/tmp/slonytest-temp.Q17311/create_set.slonik:29: ERROR: syntax error at
> or near snum
>  
> The file create_set.slonik looks like that :
>  
> [.../...]
> set add table (id=2, set id=1, origin=1, fully qualified
> name='public.mytable1', comment='mycluster table public.mytable1');
> set add sequence (id=1, set id=1, origin=1, fully qualified
> name='public.mysequence1', comment='mycluster sequence
> public.mysequence1'); snum=2
> [.../...]
>  
> Where does the 'snum=2' comes from?

It's a bug in the script. A carriage return has disappeared on line 150.

You should have

150c150,151
<     echo "set add sequence (id=${snum}, set id=1, origin=1, fully qualified
name='${seq}', comment='${CLUSTER} sequence ${seq}');" >> $SETUPSET
snum=`expr ${snum} + 1`
---
>     echo "set add sequence (id=${snum}, set id=1, origin=1, fully qualified
name='${seq}', comment='${CLUSTER} sequence ${seq}');" >> $SETUPSET
>     snum=`expr ${snum} + 1`

Best regards,
-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
Tél. 09 53 69 97 12
http://www.postgresqlfr.org