Re: Logical Replication: SELECT pg_catalog.set_config Statement appears to be hanging
Hello Tom,
thanks for the clarification. We are stumbling about this in psql (11.11)
I have now searched the release logs to find out when this will be resolved.
I found the following matching entry:
https://www.postgresql.org/docs/14/release-14.html <https://www.postgresql.org/docs/14/release-14.html>
E.1.3.1.7. System Views
.....
Improve pg_stat_activity reporting of walsender processes (Tom Lane)
Previously only SQL commands were reported.
so we have to wait for psql14, or is there something else to this effect
in an earlier release, that I failed to find?
regards
Hannes
Am 18.05.2021 um 15:15 schrieb Tom Lane:
Show quoted text
=?UTF-8?Q?Hannes_K=c3=bchtreiber?=<h.kuehtreiber@synedra.com> writes:
Hello Tom, thanks for your answer!
We found out because we are monitoring long running queries, and saw it
had been running for a month before the restart yesterday.
I just queried pg_stat_activity and it seems to be running since then.Oh, that's because pg_stat_activity continues to show the last plain-SQL
query executed by the session.I think we recently changed things so that replication commands
would be shown in pg_stat_activity too, but evidently you're running
a version older than that.regards, tom lane
Import Notes
Reply to msg id not found: 1f02ba50-1f61-5ecc-ee2b-f8c00774df6e@synedra.comReference msg id not found: 1f02ba50-1f61-5ecc-ee2b-f8c00774df6e@synedra.com
On Thu, Jun 10, 2021, 09:06 Hannes Kühtreiber <h.kuehtreiber@synedra.com>
wrote:
so we have to wait for psql14, or is there something else to this effect
in an earlier release, that I failed to find?
By definition every feature in a vX.0 release note is new as of that
release. The sentence at the top of that section states this explicitly
too.
David J.