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:[email protected]]
Sent: 30 November 2010 16:06
To: Emma Lovatt
Cc: [email protected]
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
<[email protected]> 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.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
