I have replication using Publication/Subscription and configured with REPLICA
IDENTITY DEFAULT, so it uses PK values to do the replication. Then, I´ve
imported data in a new schema and that has several tables with a record with
its PK = 0. Replication works but my application doesn´t because it needs to
see pk values > 0.
So, I have to change those records with 0 on their pk to any value, what is
the best way to do that ?
If i just change pk valued on master how will the data of that record be
replicated ?
That record will be sent to replica as update but that PK doesn´t exist on
replica server, so ...
Or do I need to update them manually on Master and Replicated servers ?
I didn´t find any info about this on Docs and because that I´m posting about
this.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html