ricardo.silva at cimsoft.pt ricardo.silva
Thu Mar 24 16:37:51 PST 2005
Hi

Sorry for the incovenience but I'm experiencing some problems in getting the replication with slony working. I get your readme file and copy it to my 2 machines, replacing only the needed fields. Everything went right until the time I have to compare the two databases and it gaves me the following error.
[postgres at localhost postgres]$ ./05MASTERCOMPARE
**** comparing sample1 ... ERROR:  column "_Slony-I_cluster_db_rowID" does not exist
FAILED - see test_1.diff for database differences
[postgres at localhost postgres]$

The replication didn't work and I think the problem is with pgbench, but I don't know how to see if it's still running?
I put it running with 
#!/bin/sh

NUMCLIENTES=2
PGBENCH_USER=postgres
HOST1=192.168.0.233
NUMTRANSACTIONS=1000
DBNAME1=TESTE

/usr/local/pgsql/bin/pgbench -s 1 -v -c $NUMCLIENTES -U $PGBENCH_USER -h $HOST1 -t $NUMTRANSACTIONS $DBNAME1

and it gaves me this
[postgres at localhost postgres]$ ./02MASTERPGBENCH
starting vacuum...end.
starting full vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 2
number of transactions per client: 1000
number of transactions actually processed: 2000/2000
tps = 122.264522 (including connections establishing)
tps = 122.363779 (excluding connections establishing)
[postgres at localhost postgres]$

Thks in advance
Ricardo Silva
ricardo.silva at cimsoft.pt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050324/a1f33078/attachment.html


More information about the Slony1-general mailing list