From: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Changing PK on replicated database |
Date: | 2019-10-16 20:47:18 |
Message-ID: | 1571258838155-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Neil | 2019-10-16 21:27:10 | Re: CVE-2018-1058 |
Previous Message | Lizeth Solis Aramayo | 2019-10-16 20:05:57 | RE: CVE-2018-1058 |