Re: logical replication problem

2019-01-28 Thread Achilleas Mantzios
On 28/1/19 12:12 μ.μ., Thomas Schweikle wrote: Hi! Setup: - db-server_A on port 5432 - db-server_B on port 5433 on db-server_A: postgres=# \dRp Liste der Publikationen Name | Eigentümer | Alle Tabellen | Inserts | Updates | Deletes --++---+--

Re: logical replication problem

2019-01-28 Thread Pavan Teja
And that's the reason for the error. In the subscriber no need of any data. Jus structure sync is enough. Try truncating the database and start the replication from fresh ull get rid of the errors Regards, Pavan On Mon 28 Jan, 2019, 3:50 PM Thomas Schweikle On Mon, Jan 28, 2019 at 11:15 AM Pavan

Re: logical replication problem

2019-01-28 Thread Thomas Schweikle
On Mon, Jan 28, 2019 at 11:15 AM Pavan Teja wrote: > > Does the db_server_B has data in it?? Yes, it has -- about 51GiByte ... Changed frequently. > Regards, > Pavan > > On Mon 28 Jan, 2019, 3:42 PM Thomas Schweikle > >> Hi! >> >> Setup: >> >> - db-server_A on port 5432 >> - db-server_B on port

logical replication problem

2019-01-28 Thread Thomas Schweikle
Hi! Setup: - db-server_A on port 5432 - db-server_B on port 5433 on db-server_A: postgres=# \dRp Liste der Publikationen Name | Eigentümer | Alle Tabellen | Inserts | Updates | Deletes --++---+-+-+- mig1 | postgres | t