[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: logical replication problem
From: Pavan Teja <pavan.postgresdba () gmail ! com>
Date: 2019-01-28 10:39:05
Message-ID: CACh9nsb2+S8=Eca4r_wTCVf+xKZUxqJx4LLUtbTaWs3pEjZ2Nw () mail ! gmail ! com
[Download RAW message or body]
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 <tschweikle@gmail.com wrote:
> On Mon, Jan 28, 2019 at 11:15 AM Pavan Teja <pavan.postgresdba@gmail.com>
> 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 <tschweikle@gmail.com
> 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
> >> ------+------------+---------------+---------+---------+---------
> >> mig1 | postgres | t | t | t | t
> >>
> >> on db-server_B:
> >> postgres=# \dRs
> >> Liste der Subskriptionen
> >> Name | Eigentümer | Eingeschaltet | Publikation
> >> ------+------------+---------------+-------------
> >> sub1 | postgres | t | {mig1}
> >>
> >> in db-server_A pg_hba.conf:
> >> local replication postgres peer
> >> host replication postgres 127.0.0.1/32 ident
> >> host replication postgres ::1/128 ident
> >>
> >> on db-server_A:
> >> postgres# CREATE PUBLICATION mig1 FOR ALL TABLES;
> >> CREATE PUBLICATION
> >>
> >> the command on db-server_B:
> >> postgres# CREATE SUBSCRIPTION sub1 CONNECTION 'host=127.0.0.1
> >> port=5432 dbname=mydb user=postgres PUBLICATION mig1;
> >> NOTICE: created replication slot "sub1" on publisher
> >> CREATE SUBSCRIPTION
> >>
> >> worked as expected.
> >> But: instead of starting replication I find Errors within db-server_B
> logs:
> >> 2019-01-24 10:57:58.549 CET [28956] LOG: Apply-Worker für logische
> >> Replikation für Subskription »sub1 « hat gestartet
> >> 2019-01-24 10:57:58.553 CET [28956] FEHLER: konnte keine Daten vom
> >> WAL-Stream empfangen: FEHLER: Publikation »mig1 « existiert nicht
> >> KONTEXT: Slot »sub1 «, Ausgabe-Plugin »pgoutput «, im Callback
> >> change, zugehörige LSN 47/B4BCA2A8
> >> 2019-01-24 10:57:58.554 CET [5982] LOG: Background-Worker »logical
> >> replication worker « (PID 28956) beendete mit Status 1
> >>
> >> Configuration was set on both servers to include
> >> wal_level = logical
> >>
> >> Any ideas why this does not work as expected? Any further ideas what
> >> to prove on db-server_A and db-server_B?
> >>
> >>
> >> --
> >> Thomas
> >>
>
>
> --
> Thomas
>
>
[Attachment #3 (text/html)]
<div dir="auto"><span style="font-family:sans-serif;font-size:12.8px">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</span><div dir="auto" \
style="font-family:sans-serif;font-size:12.8px"><br></div><div dir="auto" \
style="font-family:sans-serif;font-size:12.8px">Regards, </div><div dir="auto" \
style="font-family:sans-serif;font-size:12.8px">Pavan </div></div><br><div \
class="gmail_quote"><div dir="ltr">On Mon 28 Jan, 2019, 3:50 PM Thomas Schweikle \
<<a href="mailto:tschweikle@gmail.com">tschweikle@gmail.com</a> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">On Mon, Jan 28, 2019 at 11:15 AM \
Pavan Teja <<a href="mailto:pavan.postgresdba@gmail.com" target="_blank" \
rel="noreferrer">pavan.postgresdba@gmail.com</a>> wrote:<br> ><br>
> Does the db_server_B has data in it??<br>
<br>
Yes, it has -- about 51GiByte ... Changed frequently.<br>
<br>
> Regards,<br>
> Pavan<br>
><br>
> On Mon 28 Jan, 2019, 3:42 PM Thomas Schweikle <<a \
href="mailto:tschweikle@gmail.com" target="_blank" \
rel="noreferrer">tschweikle@gmail.com</a> wrote:<br> >><br>
>> Hi!<br>
>><br>
>> Setup:<br>
>><br>
>> - db-server_A on port 5432<br>
>> - db-server_B on port 5433<br>
>><br>
>> on db-server_A:<br>
>> postgres=# \dRp<br>
>> Liste der Publikationen<br>
>> Name | Eigentümer | Alle Tabellen | Inserts | Updates | Deletes<br>
>> ------+------------+---------------+---------+---------+---------<br>
>> mig1 | postgres | t | t | t | \
t<br> >><br>
>> on db-server_B:<br>
>> postgres=# \dRs<br>
>> Liste der Subskriptionen<br>
>> Name | Eigentümer | Eingeschaltet | Publikation<br>
>> ------+------------+---------------+-------------<br>
>> sub1 | postgres | t | {mig1}<br>
>><br>
>> in db-server_A pg_hba.conf:<br>
>> local replication postgres \
peer<br> >> host replication postgres <a \
href="http://127.0.0.1/32" rel="noreferrer noreferrer" \
target="_blank">127.0.0.1/32</a> ident<br> >> host \
replication postgres ::1/128 ident<br> \
>><br> >> on db-server_A:<br>
>> postgres# CREATE PUBLICATION mig1 FOR ALL TABLES;<br>
>> CREATE PUBLICATION<br>
>><br>
>> the command on db-server_B:<br>
>> postgres# CREATE SUBSCRIPTION sub1 CONNECTION 'host=127.0.0.1<br>
>> port=5432 dbname=mydb user=postgres PUBLICATION mig1;<br>
>> NOTICE: created replication slot "sub1" on publisher<br>
>> CREATE SUBSCRIPTION<br>
>><br>
>> worked as expected.<br>
>> But: instead of starting replication I find Errors within db-server_B \
logs:<br> >> 2019-01-24 10:57:58.549 CET [28956] LOG: Apply-Worker für \
logische<br> >> Replikation für Subskription »sub1 « hat gestartet<br>
>> 2019-01-24 10:57:58.553 CET [28956] FEHLER: konnte keine Daten vom<br>
>> WAL-Stream empfangen: FEHLER: Publikation »mig1 « existiert nicht<br>
>> KONTEXT: Slot »sub1 «, Ausgabe-Plugin »pgoutput «, im \
Callback<br> >> change, zugehörige LSN 47/B4BCA2A8<br>
>> 2019-01-24 10:57:58.554 CET [5982] LOG: Background-Worker »logical<br>
>> replication worker « (PID 28956) beendete mit Status 1<br>
>><br>
>> Configuration was set on both servers to include<br>
>> wal_level = logical<br>
>><br>
>> Any ideas why this does not work as expected? Any further ideas what<br>
>> to prove on db-server_A and db-server_B?<br>
>><br>
>><br>
>> --<br>
>> Thomas<br>
>><br>
<br>
<br>
-- <br>
Thomas<br>
<br>
</blockquote></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic