You are missing = signs afer your conninf as in the following:


 node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST 
user=$REPLICATIONUSER';
......



On September 29, 2004 10:33 am, Yogesh Sharma wrote:
> Hi
>
> I am getting following error:
>
> <stdin>:2: ERROR: syntax error at or near dbname=pgbench host=localhost
> user=postgres'
>
> When I execute this script:
>
> #!/bin/bash
>
> slonik <<_EOF_
> cluster name = $CLUSTERNAME;
> node 1 admin conninfo 'dbname=$MASTERDBNAME host=$MASTERHOST
> user=$REPLICATIONUSER';
> node 2 admin conninfo 'dbname=$SLAVEDBNAME host=$SLAVEHOST
> user=$REPLICATIONUSER';
> init cluster ( id=1, comment = 'Master Node');
> table add key (node id = 1, fully qualified name = 'public.history');
> 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);
> 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_
>
> my env is:
>
> CLUSTERNAME=slony_example
> MASTERDBNAME=pgbench
> SLAVEDBNAME=pgbenchslave
> MASTERHOST=localhost
> SLAVEHOST=192.168.59.59
> REPLICATIONUSER=postgres
> PGBENCHUSER=pgbench
>
> Postgres 7.4.5
> slonik1-1.0.2
> SuSe Enterprise 9.0
>
> Please help me understand this error message.
>
> Thanks
> Yogesh
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com