Thank you for your help!
*Erik R. Serrano Saavedra* * Data Base Administrator* El mar, 11 feb 2025 a las 4:41, Mendbayar Alzakhgui (< mendbayar....@unitel.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 <eserra...@gmail.com> > *Sent:* Tuesday, February 11, 2025 5:11 AM > *To:* Pgsql-admin <pgsql-ad...@lists.postgresql.org>; > pgadmin-support@lists.postgresql.org > *Subject:* Errors of a Postgresql replication with PowerBi > > > > You don't often get email from eserra...@gmail.com. Learn why this is > important <https://aka.ms/LearnAboutSenderIdentification> > > *ТУХАЙН ИЛГЭЭГЧ НЬ МАНАЙ ХАРИЛЦАГЧИЙН ИМЭЙЛ БИШ БАЙНА!!* > *Сэжигтэй тохиолдолд "secur...@unitel.mn <secur...@unitel.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* > > >
