On Thu, 2021-12-09 at 09:13 +0000, Avi Weinberg wrote:
> What is the best practice when dealing with Identity/Serial column in logical replication.
> Should the subscriber table have this column also defined as Identity/Serial or have it defined as regular integer?
> Is leaving it as Identity/Serial also on subscriber tables, can potentially cause a problem?
It does not really matter if you use "serial" or an identity column on
the logical standby or not. The sequence on the standby won't be advanced.
The best way to prevent conflicts from happening is *not* to modify
the data on the standby.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
