PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?
By default, CREATE SUBSCRIPTION will first copy all the existing data from the source tables. The idea is that you usually start with an empty destination database created with something like pg_restore -s.

If you don't want to have the initial data copy, create the subscription like this:

CREATE SUBSCRIPTION ...
WITH (copy_data = false);


See the documentation for details.