From: | "Vishnu S(dot)" <vishnu(dot)s(at)nestgroup(dot)net> |
---|---|
To: | "Sachin Srivastava" <sachin(dot)srivastava(at)enterprisedb(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Serial key mismatch in master and slave, while using slony |
Date: | 2010-12-18 12:12:05 |
Message-ID: | D0124DE0373A744CA8192AFA82C831170216EA80@mail-4.tvm.nestgroup.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am using Slony-I slony-I-2.0.2 in windows .I have a master and a slave
machine. The replication is working fine. When the master switches to
slave , there exists a serial key mismatch in master and slave machines.
So insertion fails in the slave machines. I am using the failover
command to switch the slave to master. Now the error message shown is
'Duplicate key violation'. On selecting the next value of the serial key
the value shown is different from the actual value. Ie the shown value
is very much less than the number of records in the table.
Thanks & Regards,
Vishnu S
***** Confidentiality Statement/Disclaimer *****
This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2010-12-18 18:29:13 | Re: DB files, sizes and cleanup |
Previous Message | Alex - | 2010-12-18 06:50:52 | Postgres 9.0 Hiding CONTEXT string in Logs |