The contents for preamable.sk are:

# file preamble.sk 
cluster name = profile_propagation;
node 1 admin conninfo = 'host=168.198.1.92 port=5432 dbname=ops_db
user=scadmin password=scadmin0';
node 2 admin conninfo = 'host=168.198.1.46 port=5432 dbname=igops.ia.db
user=scadmin password=scadmin0';




On Thu, 2011-06-23 at 08:21 +0200, "Stéphane A. Schildknecht" wrote:
> -----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-----
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

-- 
rodney <yl.wang at invantest.com>