Re: [GENERAL] Two entries with the same primary key

2012-04-13 Thread Ivan Evtuhovich
Hello Merlin, we've resynced slave and now everything is OK, thanks you for help. And only one last question, where to read about this bug, because my colleges want to know, what happens. On Fri, Apr 13, 2012 at 00:48, Merlin Moncure wrote: > On Thu, Apr 12, 2012 at 9:20 AM, Ivan Ev

Re: [GENERAL] Two entries with the same primary key

2012-04-12 Thread Ivan Evtuhovich
Monday, and I'll check, if problem solved. Thanx you for answer. On Fri, Apr 13, 2012 at 00:48, Merlin Moncure wrote: > On Thu, Apr 12, 2012 at 9:20 AM, Ivan Evtuhovich > wrote: > > Hello, > > > > More then month ago we upgrade DB from 9.0 to 9.1 with pg_upgrade. The

[GENERAL] Two entries with the same primary key

2012-04-12 Thread Ivan Evtuhovich
Hello, More then month ago we upgrade DB from 9.0 to 9.1 with pg_upgrade. Then we move DB to another server with standard pg streaming replication. Now we have two entries with the same primary key. And I do not know what to do. SELECT ctid, id from billing_invoices where id = 27362891; cti