Message-ID: <2fe941e5814512059a8add602645f8f9d3e08e40.camel@cybertec.at>
Subject: Re: Errors of a Postgresql replication with PowerBi
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Tue, 11 Feb 2025 15:08:17 +0100
In-Reply-To: 
 <CANzqJaCUJ-2boYgVsjm9ev=YwoLUfGSr-aUswTHAfMborCJCAQ@mail.gmail.com>
References: 
	<CA+dvXXsKUwbyyWUPEjiqJY_qSDHHnjj720Sjpo5cS2=zxRFZVg@mail.gmail.com>
	 <CANzqJaCUJ-2boYgVsjm9ev=YwoLUfGSr-aUswTHAfMborCJCAQ@mail.gmail.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/2fe941e5814512059a8add602645f8f9d3e08e40.camel%40cybertec.at>
Precedence: bulk

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.com=
> wrote:
> > Along with greetings, I would like to consult a problem related to a st=
reaming replication
> > slave server in Postgresql version 15 that is being used as a server fo=
r PowerBi queries.
>=20
> In the _004.jpg file, I see integer underflow.=C2=A0 Or integer overflow =
that wraps around to negative 2.1 billion.
> =C2=A0
> Maybe that column needs to be a BIGINT, and the PBI code needs=C2=A0to us=
e=C2=A0int8?

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

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.