Content-Type: multipart/alternative;
	boundary=Apple-Mail-AEAD46E1-1EB8-42F6-9484-2376DB18BCA0
Mime-Version: 1.0 (1.0)
Subject: Re: logical Replication
From: Maletin von Oertzen <oertzen@gmail.com>
In-Reply-To: <1534751989163-0.post@n3.nabble.com>
Date: Wed, 22 Aug 2018 23:14:14 +0200
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.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>
To: pavan95 <pavan.postgresdba@gmail.com>
Precedence: bulk


--Apple-Mail-AEAD46E1-1EB8-42F6-9484-2376DB18BCA0
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable

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.
>=20
> Later which I will proceed with :
> ALTER SUBSCRIPTION my_sub_name WITH REFRESH PUBLICATION WITH( COPY_DATA)
>=20
> Even then I can't see the data replicated in the subscriber side.
>=20
> Then I will go with dropping and recreating the SUBSCRIPTION on the
> subscriber side where I will see that inserted 100 records in the subscrib=
er
> side.=20
>=20
> Again will try inserting another 1000 records which will get replicated
> within microsecond(I guess).=20

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

--Apple-Mail-AEAD46E1-1EB8-42F6-9484-2376DB18BCA0
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div></div><div>At 2018-08-20 09:59 pavan95=
 wrote:</div><div><br></div><blockquote type=3D"cite"><span>Actually there a=
re no running transactions in the database. When I insert</span><br><span>th=
e data suppose 100 records in a table and after commit connect to the</span>=
<br><span>subscriber database and issue row count from that particular table=
, I am</span><br><span>finding that the data didn't got replicated.</span><b=
r><span></span><br><span>Later which I will proceed with :</span><br><span>A=
LTER SUBSCRIPTION my_sub_name WITH REFRESH PUBLICATION WITH( COPY_DATA)</spa=
n><br><span></span><br><span>Even then I can't see the data replicated in th=
e subscriber side.</span><br><span></span><br><span>Then I will go with drop=
ping and recreating the SUBSCRIPTION on the</span><br><span>subscriber side w=
here I will see that inserted 100 records in the subscriber</span><br><span>=
side. </span><br><span></span><br><span>Again will try inserting another 100=
0 records which will get replicated</span><br><span>within microsecond(I gue=
ss). </span><br></blockquote><br><div>Is it possible, that there is a "alter=
 table replica identity"-statement missing?</div><div><a href=3D"https://www=
.postgresql.org/docs/11/static/sql-altertable.html">https://www.postgresql.o=
rg/docs/11/static/sql-altertable.html</a></div></body></html>=

--Apple-Mail-AEAD46E1-1EB8-42F6-9484-2376DB18BCA0--