3 ms·
Logical replication requires a primary key. We found that out the bad way. It _is_ a critical problem.
by 1a527dd5 11mo ago
Logical replication requires a primary key. We found that out the bad way. It _is_ a critical problem.
- ahachete 11mo agoLogical replication does NOT require a primary key. It requires either a primary key, a unique index or to define a replica identity. Sure, that still boils down, in most cases, to having a PK (replica identity is normally not a good idea), but there are cases where this would not be the case.