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