Sorry I'm working on the information the DBA has given me as I myself am not a DBA but really trying hard to understand J

 

The error in the slony log is:_

 

2010-11-10 13:21:50 GMTERROR  remoteWorkerThread_1: "update only "public"."stp_seatingmaps" set paà;

" ERROR:  syntax error at or near ""

LINE 1: update only "public"."stp_seatingmaps" set paà;

 

 

This happens when that table is updated on the master and it tried to replicate to the slave producing that error, we have had to turn off the replication on that table for the moment.  We are running RedHat Enterprise Linux 5 advanced server 64 bit, Postgresql Plus Advanced server 8.4 and slony is version 2.0.3

 

Thanks for answering so quickly, I hope this is a bit more information for you

 

From: Vick Khera [mailto:vivek at khera.org] 
Sent: 30 November 2010 16:06
To: Emma Lovatt
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Replication breaking on a table and can you replicate certain parts of a table

 

On Tue, Nov 30, 2010 at 6:36 AM, Emma Lovatt
<emma.lovatt at ticketline.co.uk> wrote:

You say "replication is breaking". Please describe your symptoms
exactly.  Nobody can offer you help without knowing exactly what you
observe.  Also include details on what system you have and what
versions of your OS, Postgres, and slony you are running.

My first guess based on zero information is that someone ran a schema
alteration without running it through the slonik EXECUTE SCRIPT
command.

> Our entire database is encoding SQL_ASCII.  I found that there may be a
> possibility that the bytea column is not  replicating and it is due to the
> encoding of the database which is SQL_ASCII could anyone confirm this?

this is incorrect.  bytea columns replicate just fine.

> My second question relates to my first if I cannot replicate my bytea
> column, I would like to know if it is possible to only replicate parts of a
> table and miss out certain columns, is this possible?

no.  the minimal unit of replication is the table.

------------------------
This email was scanned by BitDefender.

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10



------------------------
This email was scanned by BitDefender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101130/848b7575/attachment.htm