public inbox for [email protected]
help / color / mirror / Atom feedFrom: Erik Serrano <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Errors of a Postgresql replication with PowerBi
Date: Tue, 11 Feb 2025 11:45:28 -0300
Message-ID: <CA+dvXXvdq5V6pWaAYKS837-1CQh0L5Ao039J5wseKci0Xm+uWA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+dvXXsKUwbyyWUPEjiqJY_qSDHHnjj720Sjpo5cS2=zxRFZVg@mail.gmail.com>
<CANzqJaCUJ-2boYgVsjm9ev=YwoLUfGSr-aUswTHAfMborCJCAQ@mail.gmail.com>
<[email protected]>
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 (<[email protected]>)
escribió:
> On Tue, 2025-02-11 at 08:48 -0500, Ron Johnson wrote:
> > On Tue, Feb 11, 2025 at 2:17 AM Erik Serrano <[email protected]>
> 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 that
> 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, sich
> 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, be
> 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.
>
>
>
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Errors of a Postgresql replication with PowerBi
In-Reply-To: <CA+dvXXvdq5V6pWaAYKS837-1CQh0L5Ao039J5wseKci0Xm+uWA@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox