in subscriber ======== --2.create same table as in publisher create table HA_LOGICAL_REPLICATION_TAB_005(id int, name text, array1 text[], array2 integer[3][3]);
Note that you did not declare "id" to be a primary key on the subscriber.
If you look in the subscriber log, you should find:
ERROR: logical replication target relation "public.ha_logical_replication_tab_005" has neither REPLICA IDENTITY index nor PRIMARY KEY and published relation does not have REPLICA IDENTITY FULL
From:
PG Bug reporting form Date: Subject:
BUG #15784: logical replication replicate data of type array for operation insert but update/delete/truncate