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
