public inbox for [email protected]  

help / color / mirror / Atom feed

From: Erik Serrano <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Errors of a Postgresql replication with PowerBi
Date: Tue, 11 Feb 2025 11:02:51 -0300
Message-ID: <CA+dvXXuFt1THJH-9h-Vfe+Wx9rXz-aq_MENuLfmbFyh4KwTS8w@mail.gmail.com> (raw)
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>

Dear Ron,

Excellent assessment Ron, Thank you very much ... I will share it with the
architect.

Thank you very much


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



El mar, 11 feb 2025 a las 10:48, Ron Johnson (<[email protected]>)
escribió:

> On Tue, Feb 11, 2025 at 2:17 AM Erik Serrano <[email protected]> wrote:
>
>>
>> Dear Postgresql community,
>>
>> 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.
>>
>> I have been receiving some comments about errors in PBi queries that fail
>> because they have problems with replication.
>>
>> The configuration of that server is basic (it has some additional
>> parameters) but I think that some additional configuration can be done that
>> allows me to improve the performance of the queries.
>>
>> I attach the errors that normally appear to me and my configuration file.
>>
>> I hope you can help me or guide me in a possible solution
>> Thank you very much in advance
>>
>>
> 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?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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]
  Subject: Re: Errors of a Postgresql replication with PowerBi
  In-Reply-To: <CA+dvXXuFt1THJH-9h-Vfe+Wx9rXz-aq_MENuLfmbFyh4KwTS8w@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