As you told, table seemed to be corrupted. I got two rows from this select:
SELECT bco_cod, pla_cod, COUNT(*) from "8357_isarq"."wm_bco_pla" GROUP BY
bco_cod, pla_cod HAVING      COUNT(*) > 1;

Ran a delete to remove the two rows and SLONY could continue on with the
processing.

Hope to get the replication finished soon in order to end the migration
from 8.3 to 9.3.

Thank you!

On Tue, Dec 16, 2014 at 12:16 PM, Andrew Sullivan <ajs at crankycanuck.ca>
wrote:
>
> On Tue, Dec 16, 2014 at 08:32:03AM -0200, Carlos Henrique Reimer wrote:
> > Hi,
> >
> > I'm trying to replicate a postgresql database 8.3 with 1TB data and about
>
> 8.3.what?  And also, is that a typo, or do you really mean 8.3?  If
> so, I hope you're aware that you're running a database system that was
> EOL'd by the community almost two years ago.
>
> On the issue:
>
> > "8357_isarq"."wm_bco_pla"; " PGRES_FATAL_ERROR ERROR:  could not create
> > unique index "pk_wm_bco_pla"
> > DETAIL:  Key (bco_cod, pla_cod)=(399, 5056110) is duplicated.
> > CONTEXT:  SQL statement "reindex table "8357_isarq"."wm_bco_pla""
>
> > The error indicates "8357_isarq"."wm_bco_pla" has duplicated rows for
> > primary key  (bco_cod, pla_cod)=(399, 5056110) but when I query the table
> > using this pk I got only one row:
> >
> > select * from "8357_isarq"."wm_bco_pla" where bco_cod=399 and pla_cod =
> > '5056110';
> >  bco_cod | pla_cod |                pla_des                | ativo |
> > conta_pai | pla_itlistserv | pla_ctacosif
> >
> ---------+---------+---------------------------------------+-------+-----------+----------------+--------------
> >      399 | 5056110 | RENDAS TRANSACOES VISA ELETRON - HBBR | S     |
> > 5056004   |           1501 | 71799003
> > (1 row)
>
> Are you quite sure that your source table isn't corrupt?  That'd be my
> first suspicion.  I'd dump the source table and look for a duplicate
> before jumping to the conclusion that you are going to "lose three
> days of replication processing".  Your replica may in fact contain a
> copy of a corrupted database, and it might be tripping on this.
>
> Best regards,
>
> A
>
> --
> Andrew Sullivan
> ajs at crankycanuck.ca
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>


-- 
Reimer
47-3347-1724 47-9183-0547 msn: carlos.reimer at opendb.com.br
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20141216/5b7b664b/attachment.htm