Hi Everybody.

I'm not sure if this is the right list, correct me if I'm wrong.

This is the first time I've worked with slony.

I made a test environment with two virtual servers working in CentOS 5.5, 
Postgresql 8.4 and Slony 2.0.6. Test environment works fine.

When moving to production I have cloned a mid size database, when replication 
starts I see at the slon log that it founds all tables to replicate. The 
problem appears when writing to a tmp archive. Following is a snippet of the 
log:

2011-02-25 18:07:32 CSTCONFIG remoteWorkerThread_1: prepare to copy 
table "public"."model_devices"
2011-02-25 18:07:32 CSTCONFIG remoteWorkerThread_1: prepare to copy 
table "public"."array_name"
2011-02-25 18:07:32 CSTCONFIG remoteWorkerThread_1: all tables for set 1 found 
on subscriber
2011-02-25 18:07:32 CSTCONFIG remoteWorkerThread_1: copy 
table "public"."provider"
2011-02-25 18:07:33 CSTCONFIG remoteWorkerThread_1: Begin COPY of 
table "public"."provider"
NOTICE:  truncate of "public"."provider" failed - doing delete
2011-02-25 18:07:33 CSTERROR  remoteWorkerThread_1: Cannot write to archive 
file /tmp/slony1_log_2_00000000000000000366.sql.tmp - not open
2011-02-25 18:07:33 CSTWARN   remoteWorkerThread_1: data copy for set 1 failed 
19 times - sleep 60 seconds

What am I doing wrong?

Regards.

-- 
IEE José Hugo Pérez Casanova

-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que est� limpio.