MIME-Version: 1.0
References: 
 <CA+dvXXsKUwbyyWUPEjiqJY_qSDHHnjj720Sjpo5cS2=zxRFZVg@mail.gmail.com>
 <CANzqJaCUJ-2boYgVsjm9ev=YwoLUfGSr-aUswTHAfMborCJCAQ@mail.gmail.com>
 <2fe941e5814512059a8add602645f8f9d3e08e40.camel@cybertec.at>
In-Reply-To: <2fe941e5814512059a8add602645f8f9d3e08e40.camel@cybertec.at>
From: Erik Serrano <eserranos@gmail.com>
Date: Tue, 11 Feb 2025 11:45:28 -0300
Message-ID: 
 <CA+dvXXvdq5V6pWaAYKS837-1CQh0L5Ao039J5wseKci0Xm+uWA@mail.gmail.com>
Subject: Re: Errors of a Postgresql replication with PowerBi
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fa274b062ddee0fa"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BdvXXvdq5V6pWaAYKS837-1CQh0L5Ao039J5wseKci0Xm%2BuWA%40mail.gmail.com>
Precedence: bulk

--000000000000fa274b062ddee0fa
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Excellent Laurens, Currently I have this parameter at 180s, but I think it
would be better at -1 to make it more dynamic,
I will apply it

Thank you very much


*Erik R. Serrano Saavedra*
*      Data Base Administrator*


El mar, 11 feb 2025 a las 11:08, Laurenz Albe (<laurenz.albe@cybertec.at>)
escribi=C3=B3:

> On Tue, 2025-02-11 at 08:48 -0500, Ron Johnson wrote:
> > On Tue, Feb 11, 2025 at 2:17=E2=80=AFAM Erik Serrano <eserranos@gmail.c=
om>
> wrote:
> > > Along with greetings, I would like to consult a problem related to a
> streaming replication
> > > slave server in Postgresql version 15 that is being used as a server
> for PowerBi queries.
> >
> > In the _004.jpg file, I see integer underflow.  Or integer overflow tha=
t
> wraps around to negative 2.1 billion.
> >
> > Maybe that column needs to be a BIGINT, and the PBI code needs to
> use int8?
>
> I see the following error in one image:
>
>   canceling statement due to conflict with recovery
>
> If you want to avoid that error and don't mind if replay of changes to
> the standby server gets delayed, set "max_standby_streaming_delay" to -1.
>
> Yours,
> Laurenz Albe
>
> --
>
> *E-Mail Disclaimer*
> Der Inhalt dieser E-Mail ist ausschliesslich fuer den
> bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
> dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
> dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung
> oder
> Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sic=
h
> in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
>
> *CONFIDENTIALITY NOTICE & DISCLAIMER
> *This message and any attachment are
> confidential and may be privileged or otherwise protected from disclosure
> and solely for the use of the person(s) or entity to whom it is intended.
> If you have received this message in error and are not the intended
> recipient, please notify the sender immediately and delete this message
> and
> any attachment from your system. If you are not the intended recipient, b=
e
> advised that any use of this message is prohibited and may be unlawful,
> and
> you must not copy this message or attachment or disclose the contents to
> any other person.
>
>
>

--000000000000fa274b062ddee0fa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Excellent Laurens, Currently I have this parameter at=
 180s, but I think it would be better at -1 to make it more dynamic,</div><=
div>I will apply it</div><div><br></div><div>Thank you very much</div><div>=
<div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signatur=
e"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div><br><i><b><br></=
b></i></div><div><i><b><font size=3D"4">Erik R. Serrano Saavedra</font></b>=
</i></div><div><i style=3D"font-size:12.8px"><b>=C2=A0 =C2=A0 =C2=A0 Data B=
ase Administrator</b></i></div><div><br></div><div><i><font style=3D"font-s=
ize:12pt" face=3D"Times New Roman" size=3D"3"><b>
</b></font></i><i><font style=3D"font-size:12pt" face=3D"Times New Roman" s=
ize=3D"3"><b><font style=3D"font-size:10pt" size=3D"2"></font></b></font></=
i></div></div></div></div></div></div><br></div><br><div class=3D"gmail_quo=
te gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">El mar, 11 =
feb 2025 a las 11:08, Laurenz Albe (&lt;<a href=3D"mailto:laurenz.albe@cybe=
rtec.at">laurenz.albe@cybertec.at</a>&gt;) escribi=C3=B3:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex">On Tue, 2025-02-11 at 08:48 -0500=
, Ron Johnson wrote:<br>
&gt; On Tue, Feb 11, 2025 at 2:17=E2=80=AFAM Erik Serrano &lt;<a href=3D"ma=
ilto:eserranos@gmail.com" target=3D"_blank">eserranos@gmail.com</a>&gt; wro=
te:<br>
&gt; &gt; Along with greetings, I would like to consult a problem related t=
o a streaming replication<br>
&gt; &gt; slave server in Postgresql version 15 that is being used as a ser=
ver for PowerBi queries.<br>
&gt; <br>
&gt; In the _004.jpg file, I see integer underflow.=C2=A0 Or integer overfl=
ow that wraps around to negative 2.1 billion.<br>
&gt; =C2=A0<br>
&gt; Maybe that column needs to be a BIGINT, and the PBI code needs=C2=A0to=
 use=C2=A0int8?<br>
<br>
I see the following error in one image:<br>
<br>
=C2=A0 canceling statement due to conflict with recovery<br>
<br>
If you want to avoid that error and don&#39;t mind if replay of changes to<=
br>
the standby server gets delayed, set &quot;max_standby_streaming_delay&quot=
; to -1.<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
-- <br>
<br>
*E-Mail Disclaimer*<br>
Der Inhalt dieser E-Mail ist ausschliesslich fuer den <br>
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat <=
br>
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, <b=
r>
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
 <br>
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich =
<br>
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.<br>
<br>
*CONFIDENTIALITY NOTICE &amp; DISCLAIMER<br>
*This message and any attachment are <br>
confidential and may be privileged or otherwise protected from disclosure <=
br>
and solely for the use of the person(s) or entity to whom it is intended. <=
br>
If you have received this message in error and are not the intended <br>
recipient, please notify the sender immediately and delete this message and=
 <br>
any attachment from your system. If you are not the intended recipient, be =
<br>
advised that any use of this message is prohibited and may be unlawful, and=
 <br>
you must not copy this message or attachment or disclose the contents to <b=
r>
any other person.<br>
<br>
<br>
</blockquote></div>

--000000000000fa274b062ddee0fa--