Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thqqz-007cWd-Tt for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2025 14:03:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1thqqy-00B4G1-ML for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2025 14:03:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thqqy-00B4D5-AN for pgsql-admin@lists.postgresql.org; Tue, 11 Feb 2025 14:03:08 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1thqqw-000Dmp-22 for pgsql-admin@lists.postgresql.org; Tue, 11 Feb 2025 14:03:07 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-54505a75445so3388277e87.1 for ; Tue, 11 Feb 2025 06:03:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739282585; x=1739887385; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=D5vTA7wOcbE1NHX2IDuE8linBew8DXhWu3yEy2f3C58=; b=Xj4AHql0sRvguqTU4RYe2bpjXvXF32zv7/yVVO3w+BQmgmDKQn0aoQN6p+R4nmwF1b U7hNYtnwSI82fcDj2bZccudDYPM5xNVWxEnXIyvgjlUK18j3vjVyYV/ZoS7N+y7MprkG z/HtaxSZLr5fSc8cY/+LAXscaokWJ/m1kkOWVl97DYFkNS1pTRX3cyDiXZCCJlAiou8P +4XJbrp2eN42RZWRfPFD4qRKpVOvmwNcGyCsBQ7yyLoMEtm17Umwny1cPJ3iDbNONQBx +a+daWOHwNlEW2dcXxf4aSqSTU9e6BzYd7nVbXaGm20Qx9WDYDzjoCoID/7ppHiPanuI lBVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739282585; x=1739887385; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=D5vTA7wOcbE1NHX2IDuE8linBew8DXhWu3yEy2f3C58=; b=CZXoSiRRqyvC7j54tFsmQQJQA6Wnb8RRhveTcoHNir86xFLtZJDtPfZiAHFDqe72ib 0T6yi5Sb/mgn9y3bZCIBmbDDItT2XqNRX+BRMR2F4UYKTlas74ySDO2OxEwlc7Cf03SN on+DrbxuB0yrwRHHMcefu9VcEOrLsdE3rtRusI5+CCsqDfMp+hAzobTElkjgHZJ1lkyE bxaDnIwiqNADPVQPaN4qxB5EhvZCgvVz5ycELlefVjM/vpgN90Qy4KdAVc5PLJ4jOI1i EZnPstZUaDQdx+I6vKIYCBwuSR3B7S/vm/reN9Al9UbgccGRjX4x9ayqDHpV0zSL0ppl pobg== X-Gm-Message-State: AOJu0YyXWFkzmbqzqX5r5m9dCWTaUrbqij+14fTHtStsQeOAuF2KnRK8 puVj+eYdbwHDqXqefzvS6KmPF6xLpsJeqh3taYc9xi4oMDll9K7NnAH85UDHm5ng9NNEFBRiPOz teGdLzyamvIZkggr8AI3Jf1r4LOo= X-Gm-Gg: ASbGncuZPoYR6vuTUKSErhbRvaGIfL9LyrW2xBIzjvQItKf2wv2s+tvWgFbVZJnO4S0 hjMDVjTq8XJefKnhDSgaaOMyE/m+UrMHfCWSDa5KRnI2ljm1JMR+d9mmGBebw2GxybVN/WFiw X-Google-Smtp-Source: AGHT+IGETE1PvItbJwcFvjHx0Vrn5qNmWdE1vakkWUIYFJtSv8lzr8cuFHouuyb02nPCp2h1uZXWETxrwYKfQJPu5Mg= X-Received: by 2002:a05:6512:238d:b0:544:ee5:87aa with SMTP id 2adb3069b0e04-54414aae102mr4823616e87.4.1739282583085; Tue, 11 Feb 2025 06:03:03 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Erik Serrano Date: Tue, 11 Feb 2025 11:02:51 -0300 X-Gm-Features: AWEUYZl_iMioFVqy5bElEfOVDYyRUZIJQRWQJZFgTWtYp2VNl3NYh8Cw0Gy4dmU Message-ID: Subject: Re: Errors of a Postgresql replication with PowerBi To: Ron Johnson Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000876c3c062dde48b1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000876c3c062dde48b1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 () escribi=C3=B3: > On Tue, Feb 11, 2025 at 2:17=E2=80=AFAM Erik Serrano 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 bein= g >> used as a server for PowerBi queries. >> >> I have been receiving some comments about errors in PBi queries that fai= l >> 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 t= hat >> 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 int= 8? > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --000000000000876c3c062dde48b1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Dear Ron,

Excellent assessme= nt Ron, Thank you very much ... I will share it with the architect.

Thank you very much


Erik R. Serrano Saavedra
=C2=A0 =C2=A0 =C2=A0=C2=A0Data Base Administrator<= /i>



El mar, 11 = feb 2025 a las 10:48, Ron Johnson (<ronljohnsonjr@gmail.com>) escribi=C3=B3:
On= Tue, Feb 11, 2025 at 2:17=E2=80=AFAM Erik Serrano <eserranos@gmail.com> wrote:

Dear Postgresql community,

= Along with greetings, I would like to consult a problem related to a stream= ing replication slave server in Postgresql version 15 that is being used as= a server for PowerBi queries.

I have been receiving some comments a= bout errors in PBi queries that fail because they have problems with replic= ation.

The configuration of that server is basic (it has some additi= onal 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 h= ope you can help me or guide me in a possible solution
Thank you very mu= ch in advance


In the _0= 04.jpg file, I see integer underflow.=C2=A0 Or integer overflow that wraps = around to negative 2.1 billion.
=C2=A0
Maybe that colum= n needs to be a BIGINT, and the PBI code needs=C2=A0to use=C2=A0int8?
=

--
<= div dir=3D"ltr" class=3D"gmail_signature">
Death to <Red= acted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--000000000000876c3c062dde48b1--