-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

Le 23/06/2011 06:52, rodney a écrit :
> Hi all
> 
> I set up slony to replicate 3 tables from one opensuse pc (master node)
> to another opensuse pc (slave node). It works well at first. After
> running for few days, it suddenly come out the error message of -
> 
> ERROR: Slony-I: Table euprofiles is replicated and cannot be modified on
> a subscriber node - role=0

Could you execute \d euprofiles on every node and give us the result?

Do you have any message in slony logfile?

> 
> euprofiles is one of the tables being replicated by slony.
> 
> I know that this message may occur if you are trying to write to the
> table of slave node. But here I am writing to master node only.

For some reason, it now thinks the table is on the slave.
How do you connect to your databases ? Direct connection? Through a virtual IP?

Is there any auto-magical switch in your infrastructure?

Regards,
- -- 
Stéphane Schildknecht
Loxodata
Contact régional PostgreSQL

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk4C22cACgkQA+REPKWGI0Ep/wCgwI9yUvPcrWAyKYybSVQ7f9hG
SvkAoIiD7nMi4uFxaYyJDiI5i90lsP1o
=coBk
-----END PGP SIGNATURE-----