Wed Sep 29 19:06:41 PDT 2004
- Previous message: [Slony1-general] error in slonik execution
- Next message: [Slony1-general] error in slonik execution
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] error in slonik execution
- Next message: [Slony1-general] error in slonik execution
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list