pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Maletin von Oertzen <oertzen@gmail.com>
To: pavan95 <pavan.postgresdba@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: logical Replication
Date: Wed, 22 Aug 2018 23:14:14 +0200
Message-ID: <941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com> (raw)
In-Reply-To: <1534751989163-0.post@n3.nabble.com>
References: <1534224580242-0.post@n3.nabble.com>
	<emeb045759-a361-420c-a956-011d96e0e4f4@iboss01081>
	<1534746282900-0.post@n3.nabble.com>
	<b4aa40be-d9af-de0e-c9dd-e4e42da0b0df@matrix.gatewaynet.com>
	<1534747341264-0.post@n3.nabble.com>
	<d6ed4da6-2cde-77f2-77bd-8e0d921fc61f@matrix.gatewaynet.com>
	<1534748661624-0.post@n3.nabble.com>
	<17b9b7a5-5377-b904-0e8a-e72e72efe1ef@matrix.gatewaynet.com>
	<1534750828102-0.post@n3.nabble.com>
	<11f06cb4-8e48-7090-76e0-438b54c70660@matrix.gatewaynet.com>
	<1534751989163-0.post@n3.nabble.com>

At 2018-08-20 09:59 pavan95 wrote:

> Actually there are no running transactions in the database. When I insert
> the data suppose 100 records in a table and after commit connect to the
> subscriber database and issue row count from that particular table, I am
> finding that the data didn't got replicated.
> 
> Later which I will proceed with :
> ALTER SUBSCRIPTION my_sub_name WITH REFRESH PUBLICATION WITH( COPY_DATA)
> 
> Even then I can't see the data replicated in the subscriber side.
> 
> Then I will go with dropping and recreating the SUBSCRIPTION on the
> subscriber side where I will see that inserted 100 records in the subscriber
> side. 
> 
> Again will try inserting another 1000 records which will get replicated
> within microsecond(I guess). 

Is it possible, that there is a "alter table replica identity"-statement missing?
https://www.postgresql.org/docs/11/static/sql-altertable.html=

view thread (31+ messages)  latest in thread

Message-ID: <941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com>
Permalink:  ../941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com/
Also on:    postgresql.org/message-id/941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: oertzen@gmail.com, pavan.postgresdba@gmail.com
  Subject: Re: logical Replication
  In-Reply-To: <941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox