Re: Logical replication: duplicate key problem

2018-03-19 Thread Adrian Klaver
On 03/19/2018 12:30 AM, Johann Spies wrote: I have followed the following process: * pg_dump --schema-only on server 1 * restored that schema-only dump on server 2 * created a publication on server 1 including all the tables on server 1 * created a subscription on server 2 Server 2 does not get

Logical replication: duplicate key problem

2018-03-19 Thread Johann Spies
I have followed the following process: * pg_dump --schema-only on server 1 * restored that schema-only dump on server 2 * created a publication on server 1 including all the tables on server 1 * created a subscription on server 2 Server 2 does not get updated data for the schema involved from any