Yogesh Sharma ysharma
Wed Sep 29 19:00:38 PDT 2004
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



More information about the Slony1-general mailing list