pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSerial key is different in master and slave machine
2+ messages / 2 participants
[nested] [flat]
* Serial key is different in master and slave machine
@ 2010-12-18 12:25 Vishnu S. <vishnu.s@nestgroup.net>
2010-12-18 14:53 ` Re: Serial key is different in master and slave machine Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Vishnu S. @ 2010-12-18 12:25 UTC (permalink / raw)
To: Vibhor Kumar <vibhor.aim@gmail.com>; +Cc: pgsql-admin
Hi,
I am usinf Slony slony-I-2.0.2 in windows. I have a Master and a slave
machine. When the master machine is failed, I have executed the failover
script and the slave is switched to master. My problem is that while
inserting a record into the current master machine, it will show an
error saying that Duplicate key value. Please help me to overcome this
error
***** 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Serial key is different in master and slave machine
2010-12-18 12:25 Serial key is different in master and slave machine Vishnu S. <vishnu.s@nestgroup.net>
@ 2010-12-18 14:53 ` Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Vibhor Kumar @ 2010-12-18 14:53 UTC (permalink / raw)
To: Vishnu S. <vishnu.s@nestgroup.net>; +Cc: pgsql-admin
On Dec 18, 2010, at 5:55 PM, Vishnu S. wrote:
>
>
> Hi,
>
>
> I am usinf Slony slony-I-2.0.2 in windows. I have a Master and a slave
> machine. When the master machine is failed, I have executed the failover
> script and the slave is switched to master. My problem is that while
> inserting a record into the current master machine, it will show an
> error saying that Duplicate key value. Please help me to overcome this
> error
This means you haven't replicated the Sequences using Slony on Slave.
To overcome this problem, you have reset the sequences on New Master using Following command:
SELECT pg_catalog.setval('<sequencenumber>', <nextvalof sequence on Old Master>, true);
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-12-18 14:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-18 12:25 Serial key is different in master and slave machine Vishnu S. <vishnu.s@nestgroup.net>
2010-12-18 14:53 ` Vibhor Kumar <vibhor.aim@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox