public inbox for [email protected]  

help / color / mirror / Atom feed

From: Erik Serrano <[email protected]>
To: Mendbayar Alzakhgui <[email protected]>
Cc: Pgsql-admin <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Errors of a Postgresql replication with PowerBi
Date: Tue, 11 Feb 2025 09:45:08 -0300
Message-ID: <CA+dvXXvT0wWnui-ws7ba1QHs2_cVvT8wtYgX_c9QHo_BD5pETw@mail.gmail.com> (raw)
In-Reply-To: <SEZPR01MB57489DF40494A1D4858F3BFBEAFD2@SEZPR01MB5748.apcprd01.prod.exchangelabs.com>
References: <CA+dvXXsKUwbyyWUPEjiqJY_qSDHHnjj720Sjpo5cS2=zxRFZVg@mail.gmail.com>
	<SEZPR01MB57489DF40494A1D4858F3BFBEAFD2@SEZPR01MB5748.apcprd01.prod.exchangelabs.com>

Thank you for your help!


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


El mar, 11 feb 2025 a las 4:41, Mendbayar Alzakhgui (<
[email protected]>) escribió:

> Hi Erik,
>
> I’m 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’ve provided I’ve seen it like the replica server has
> failed somehow, check connection and need to check if it’s 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 <[email protected]>
> *Sent:* Tuesday, February 11, 2025 5:11 AM
> *To:* Pgsql-admin <[email protected]>;
> [email protected]
> *Subject:* Errors of a Postgresql replication with PowerBi
>
>
>
> You don't often get email from [email protected]. Learn why this is
> important <https://aka.ms/LearnAboutSenderIdentification;
>
> *ТУХАЙН ИЛГЭЭГЧ НЬ МАНАЙ ХАРИЛЦАГЧИЙН ИМЭЙЛ БИШ БАЙНА!!*
> *Сэжигтэй тохиолдолд "[email protected] <[email protected]>" рүү заавал
> мэдэгдэнэ үү.*
>
>
>
> 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
>
> Regards
>
>
>
>
>
> *Erik R. Serrano Saavedra*
>
> *      Data Base Administrator*
>
>
>

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+dvXXvT0wWnui-ws7ba1QHs2_cVvT8wtYgX_c9QHo_BD5pETw@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