Hi All;

We are replicating from a PostgreSQL 9.2 database (our Master) to a 
PostgreSQL 9.4 database (our slave) - server encoding is UTF8

The slon process for the slave has this entry:

2015-12-22 11:28:31 CST ERROR  remoteWorkerThread_1: PQputCopyData() - 
server closed the connection unexpectedly
     This probably means the server terminated abnormally
     before or while processing the request.
2015-12-22 11:28:31 CST WARN   remoteWorkerThread_1: data copy for set 1 
failed 1 times - sleep 15 seconds
FATAL:  invalid frontend message type 166
2015-12-22 11:28:31 CST ERROR  remoteWorkerThread_1: "rollback 
transaction" PGRES_FATAL_ERROR
2015-12-22 11:28:31 CST CONFIG slon: child terminated signal: 9; pid: 
12450, current worker pid: 12450
2015-12-22 11:28:31 CST CONFIG slon: restart of worker in 10 seconds

The process then begins to copy seemingly successful initial table sync's
however the postgresql log file has entries like this:


2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ ERROR:  out of memory
2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ DETAIL:  Cannot 
enlarge string buffer containing 0 bytes by 1572761385 more bytes.
2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ CONTEXT:  COPY 
/*[table name] */, line 2332808
2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ STATEMENT:  select 
"_/*[schema name]*/".prepareTableForCopy(11); copy "public"."/*[table 
name]*/" /*...*/  from stdin;



2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ LOG:  could not 
send data to client: Broken pipe
2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ FATAL:  connection 
to client lost
2015-12-22 14:56:10 UTC /*[db name] [cluster name]*/ LOG:  could not 
send data to client: Broken pipe
2015-12-22 14:56:10 UTC /*[db name] [cluster name]*/ FATAL:  connection 
to client lost
2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ ERROR:  invalid 
byte sequence for encoding "UTF8": 0x9d
2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ CONTEXT:  COPY 
transcript_indices, line 35227547
2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ STATEMENT:  select 
"_/*[schema name]*/".prepareTableForCopy(7); copy "public"."/*[table 
name]*/" /*...*/ from stdin;
2015-12-22 17:28:54 UTC /*[db name] [cluster name]*/ FATAL:  invalid 
frontend message type 166



Thoughts?

Thanks in advance...


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20151222/537435e3/attachment.htm