Re: Errors of a Postgresql replication with PowerBi

Thank you for your help!

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

El mar, 11 feb 2025 a las 4:41, Mendbayar Alzakhgui (<
mendbayar(dot)alz(at)unitel(dot)mn>) 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 <eserranos(at)gmail(dot)com>
> *Sent:* Tuesday, February 11, 2025 5:11 AM
> *To:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>;
> pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject:* Errors of a Postgresql replication with PowerBi
>
>
>
> You don't often get email from eserranos(at)gmail(dot)com(dot) Learn why this is
> important <https://aka.ms/LearnAboutSenderIdentification>
>
> *ТУХАЙН ИЛГЭЭГЧ НЬ МАНАЙ ХАРИЛЦАГЧИЙН ИМЭЙЛ БИШ БАЙНА!!*
> *Сэжигтэй тохиолдолд "Security(at)unitel(dot)mn <Security(at)unitel(dot)mn>" рүү заавал
> мэдэгдэнэ үү.*
>
>
>
> 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*
>
>
>