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 a...@crankycanuck.ca _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general