On 10/16/19 1:47 PM, PegoraroF10 wrote:
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 ...
I'm not following. You said above the replication worked with the
records where PK = 0, it was your application that could not find them.
If that is true then the records should be on the replica server,
correct? In that case it would just be an update.
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
--
Adrian Klaver
adrian.kla...@aklaver.com
