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 1thtMX-0088nM-Eu for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2025 16:43:53 +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 1thtMW-00CvaZ-89 for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2025 16:43:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1thpdk-00AOfy-EZ; Tue, 11 Feb 2025 12:45:24 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1thpdh-000Dri-20; Tue, 11 Feb 2025 12:45:24 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-54298ec925bso6933187e87.3; Tue, 11 Feb 2025 04:45:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739277920; x=1739882720; 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=FWVDNmbk365r4rJzGjOIItEXhm6Ar2FiAU5hV2kvdAc=; b=D8iNrM4kmaFZPJQ0O3uwQ27qjFVqq17hxa+G33fdCCsMCoEiu6ZOCdWMh3oMnIT3I1 Z/ONf4BKDOnqM++C/mzqQ0EibWVcDfC44uxFe/IDNS2yaYUYwwjB7ZbWfQSHCINGah2O 5NrTZA7l6Zd4TEmRo5ccB+FpYuOjj+IcV9sbJV9/xUh5CW6RIHWnIgzOd4QokEiqwnvL nUndIeQejwmZW+kPxi46ZVrbTd5Xeh/Fo663ACcZiKnCjhBVR7ph6xGJkcFeuN3D9Wff 88o4cykd1HPcNVW9ybPwxDvtiWcACByQmyK7+YH3G2INU6iYcm4cYtQrbyAZNjYhqecy JQKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739277920; x=1739882720; 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=FWVDNmbk365r4rJzGjOIItEXhm6Ar2FiAU5hV2kvdAc=; b=O07LprpWmwSGxfX5fT9OuNuIbHWm9vDYM8YL1uIB+gga0RyNKMChTOnuQ+1vj8Du6L XYJ4L5xEWInIDDOg6IRWsMT1v5RtXN10DJtueMU0ctmlVQqI78zbkAVBveB9RyK6Y3YX eYj26Gr201rZCvik6FUAe6vQHyVB/ZLkI29nYWIQt0/lF2N5+iWLUkeguC/a/FAyBx0r xOtnNFO51zjL5mTUBZhHF/yFtg301irYTGo0ywCOC5QURIhqm5BOZsmWq/mDnMy9Vq9p 8MepvWU9IQLBYYLRBQYtg+TacxWQK1S1mABfEjS0fqnfHHf5pRnxvkPNCviXi1iuQaNK ulZg== X-Forwarded-Encrypted: i=1; AJvYcCVjHuNCPxpvtuX9HYfcde7gajbbzDjoYX9nPg/lr4idqVfn0ML3ThNHCag1qRvs+NfHZF+Xdv7oCObBx3AHNA0=@lists.postgresql.org X-Gm-Message-State: AOJu0YwTu4Al9XrF8IROHTt6iJ5Q63y8JlkwxdoJWfaxOjfI7XI4iWfn HVYLJ/VIVGFlgN839R/ncy+13nGLKmS2wbl8k0K/nBgBAqEqIrseA/G6IOV85vyyhd/HPn3M4aR YWaPywDhFDSwrWjF9DthLaN9jZ5o= X-Gm-Gg: ASbGnctZOXRL6TfRnsXyAGv5Om2C6fIjKbcN33Pau0g7RrAfQJl8PWhed3zl6Sqnwhi WzBStdcH+9k2AtO3ATuTyTpZmxHMFYIiqmwDE6BNmBXotmqLhGhqx4uqPjzyfXx+o/D4tszlT X-Google-Smtp-Source: AGHT+IECfrDdpwxEQrNNOxMLuriY9FWDmxOg+6BNiDHDseMgUATd+B0VQFccJSQ4b8a1QgAfazf0KXxcTXvsUoGJyeM= X-Received: by 2002:a05:6512:3581:b0:545:8cb:2183 with SMTP id 2adb3069b0e04-54508cb22cfmr2270408e87.29.1739277919927; Tue, 11 Feb 2025 04:45:19 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Erik Serrano Date: Tue, 11 Feb 2025 09:45:08 -0300 X-Gm-Features: AWEUYZn04Kxn1aWAwyE2BVKzF9I0G5vhHrnvjOHwpaj5NUTTKbP-kjTQA9cePZg Message-ID: Subject: Re: Errors of a Postgresql replication with PowerBi To: Mendbayar Alzakhgui Cc: Pgsql-admin , "pgadmin-support@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000954521062ddd32b6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000954521062ddd32b6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you for your help! *Erik R. Serrano Saavedra* * Data Base Administrator* El mar, 11 feb 2025 a las 4:41, Mendbayar Alzakhgui (< mendbayar.alz@unitel.mn>) escribi=C3=B3: > Hi Erik, > > I=E2=80=99m not an expert on Postgres, but I found out that configuration= tuning > needed on the Postgresql server, like shared_buffers, work mem etc. > > And from the logs you=E2=80=99ve provided I=E2=80=99ve seen it like the r= eplica server has > failed somehow, check connection and need to check if it=E2=80=99s alive = from the > primary server like > > > > select * from pg_stat_replication_slots; > > select * from pg_replication_slots; > > > > And better to check if the replica has error log on it. > > > > Sincerely, > > > * Mendbayar A.* > > > > *From:* Erik Serrano > *Sent:* Tuesday, February 11, 2025 5:11 AM > *To:* Pgsql-admin ; > pgadmin-support@lists.postgresql.org > *Subject:* Errors of a Postgresql replication with PowerBi > > > > You don't often get email from eserranos@gmail.com. Learn why this is > important > > *=D0=A2=D0=A3=D0=A5=D0=90=D0=99=D0=9D =D0=98=D0=9B=D0=93=D0=AD=D0=AD=D0= =93=D0=A7 =D0=9D=D0=AC =D0=9C=D0=90=D0=9D=D0=90=D0=99 =D0=A5=D0=90=D0=A0=D0= =98=D0=9B=D0=A6=D0=90=D0=93=D0=A7=D0=98=D0=99=D0=9D =D0=98=D0=9C=D0=AD=D0= =99=D0=9B =D0=91=D0=98=D0=A8 =D0=91=D0=90=D0=99=D0=9D=D0=90!!* > *=D0=A1=D1=8D=D0=B6=D0=B8=D0=B3=D1=82=D1=8D=D0=B9 =D1=82=D0=BE=D1=85=D0= =B8=D0=BE=D0=BB=D0=B4=D0=BE=D0=BB=D0=B4 "Security@unitel.mn " =D1=80=D2=AF=D2=AF =D0=B7=D0=B0=D0=B0=D0=B2=D0=B0=D0=BB > =D0=BC=D1=8D=D0=B4=D1=8D=D0=B3=D0=B4=D1=8D=D0=BD=D1=8D =D2=AF=D2=AF.* > > > > 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 th= at > 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 > > Regards > > > > > > *Erik R. Serrano Saavedra* > > * Data Base Administrator* > > > --000000000000954521062ddd32b6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thank you for your help!=C2=A0


Erik R. Serrano Saavedra
<= div>=C2=A0 =C2=A0 =C2=A0=C2=A0Data Base Ad= ministrator


El mar, 11 feb 2025 a las 4:41, Mendbayar Alzakhgui (<<= a href=3D"mailto:mendbayar.alz@unitel.mn">mendbayar.alz@unitel.mn>) = escribi=C3=B3:
<= div class=3D"msg1076041691437043815">

Hi Erik,

I=E2=80=99m not an expert on Postgres, but I found out that configuration t= uning needed on the Postgresql server, like shared_buffers, work mem etc.

And from the logs you=E2=80=99ve provided I=E2=80=99= ve seen it like the replica server has failed somehow, check connection and= need to check if it=E2=80=99s alive from the primary server like

=C2=A0

select * from pg_stat_replication_slots;

select * from pg_replication_slots;

=C2=A0

And better to check if the replica has error log on = it.

=C2=A0

Sincerely,


Mendbayar A.

=C2=A0

From: Erik Serrano <eserranos@gmail.com>
Sent: Tuesday, February 11, 2025 5:11 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; pgadmin-supp= ort@lists.postgresql.org
Subject: Errors of a Postgresql replication with PowerBi

=C2=A0

You don't often get email from eserranos@gmail.com. Learn why this is important

=D0=A2=D0=A3=D0=A5=D0=90=D0= =99=D0=9D =D0=98=D0=9B=D0=93=D0=AD=D0=AD=D0=93=D0=A7 =D0=9D=D0=AC =D0=9C=D0= =90=D0=9D=D0=90=D0=99 =D0=A5=D0=90=D0=A0=D0=98=D0=9B=D0=A6=D0=90=D0=93=D0= =A7=D0=98=D0=99=D0=9D =D0=98=D0=9C=D0=AD=D0=99=D0=9B =D0=91=D0=98=D0=A8 =D0= =91=D0=90=D0=99=D0=9D=D0=90!!
=D0=A1=D1=8D=D0=B6=D0=B8=D0=B3=D1=82=D1=8D=D0=B9 =D1=82=D0=BE=D1=85=D0= =B8=D0=BE=D0=BB=D0=B4=D0=BE=D0=BB=D0=B4 "Security@unitel.mn" =D1=80=D2=AF=D2=AF = =D0=B7=D0=B0=D0=B0=D0=B2=D0=B0=D0=BB =D0=BC=D1=8D=D0=B4=D1=8D=D0=B3=D0=B4= =D1=8D=D0=BD=D1=8D =D2=AF=D2=AF.

=C2=A0

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 about errors in PBi queries that fail b= ecause they have problems with replication.

The configuration of that server is basic (it has some additional parameter= s) but I think that some additional configuration can be done that allows m= e 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

Regards

=C2=A0

=C2=A0

E= rik R. Serrano Saavedra

= =C2=A0 =C2=A0 =C2=A0=C2=A0Data Base Administrator

=C2=A0

--000000000000954521062ddd32b6--