search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.02k stars 154 forks source link

Unique constraint violations? AWS DMS & Aurora PostgreSQL v14, pglogical v2.4.1 #409

Closed awitterackspace closed 1 year ago

awitterackspace commented 1 year ago

I have a case open with AWS but thought I'd pass this along here in case this is a quick fix.

I am migrating one singular table from postgres14 to postgres14 (same server actually) using AWS DMS. pglogical is barking at me for violating a unique key constraint (primary key) for a row that does not have a duplicate. Is this a known issue (maybe with these version combinations or something...?) or are there any recommendations for troubleshooting steps I can take to narrow down what the problem is? The DMS task always fails on the same record which DOES NOT have a duplicate anywhere.

awitterackspace commented 1 year ago

Rolled back my Aurora/PostgreSQL cluster from v14.5 to v13.7 and it fixed this issue.