Hi,

This is the first time I've tried to set up replication using slony and
I would appreciate someone's help please:

Slony 1.0.5
PG 8.0.2
Solaris 8

I configured slony with the following:

$ ./configure --with-pgsourcetree=/home/postgres/802src/postgresql-8.0.2
--enable-thread-safety

Does the -- enable-thread-safety need a value? I couldn't see anything
to say that it does.

I'm assuming that I do not have to apply patch
threadsafe-libpq-742.diff.gz as this is for PG7.4.2??

I followed the instructions in the
slony/doc/howto/slony-I-basic-mstr-slv.txt doc

When I execute the following for both the master and slave nodes (by the
way the nodes are the same machine - using IP address rather than
localhost)

intyonb01-postgres ># slon $CLUSTERNAME "dbname=$MASTERDBNAME
user=$REPLICATIONUSER host=$MASTERHOST"

I get the following:

CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id = 1
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=2 no_comment='Slave node'
CONFIG storePath: pa_server=2 pa_client=1
pa_conninfo="dbname=pgbenchslave host=172.18.4.129 user=postgres"
pa_connretry=10
CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables'
CONFIG main: configuration complete - starting threads
CONFIG enableNode: no_id=2
ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,
ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8
from "_slony_example".sl_event e where (e.ev_origin = '2' and e.ev_seqno
> '0') order by e.ev_origin, e.ev_seqno" - could not receive data from
server: Error 0

intyonb01-postgres ># slon $CLUSTERNAME "dbname=$SLAVEDBNAME
user=$REPLICATIONUSER host=$SLAVEHOST"
CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id = 2
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=1 no_comment='Master Node'
CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=pgbench
host=172.18.4.129 user=postgres" pa_connretry=10
CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables'
WARN   remoteWorker_wakeup: node 1 - no worker thread
CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='f'
WARN   remoteWorker_wakeup: node 1 - no worker thread
CONFIG main: configuration complete - starting threads
CONFIG enableNode: no_id=1
ERROR  remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip,        ev_type,        ev_data1, ev_data2,
ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8
from "_slony_example".sl_event e where (e.ev_origin = '1' and e.ev_seqno
> '6') order by e.ev_origin, e.ev_seqno" - could not receive data from
server: Error 0


Any help in resolving this issue would be much appreciated.

Thanks.
Nigel


Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes.

Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it has been sent. If you have reason to believe that you are not the intended recipient of this communication, please contact the sender immediately. No employee is authorised to conclude any binding agreement on behalf of ioko with another party by e-mail without prior express written confirmation.

ioko365 Ltd, Innovation Close, York Science Park, York, YO10 5ZD, ENGLAND.
Tel +44 (0) 1904 438 000. VAT reg 656 2443 31. Reg no 3048367. All rights reserved.