Re: Logical Replication: SELECT pg_catalog.set_config Statement appears to be hanging

On Thu, Jun 10, 2021, 09:06 Hannes Kühtreiber 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

Re: Logical Replication: SELECT pg_catalog.set_config Statement

Hello Jeremy, thanks for your input (and sorry for the delay). for our monitoring we query like this SELECT EXTRACT(epoch FROM (LOCALTIMESTAMP - pg_stat_activity.query_start))::integer AS age FROM pg_stat_activity WHERE pg_stat_activity.state = 'active' AND query NOT LIKE 'autovacuum:%' ORDER

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

Re: Logical Replication: SELECT pg_catalog.set_config Statement

> > 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. > > taimusz=# SELECT pid, query_start, usename, left(query,70) > FROM pg_stat_activity >

Re: Logical Replication: SELECT pg_catalog.set_config Statement

=?UTF-8?Q?Hannes_K=c3=bchtreiber?= 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

Re: Logical Replication: SELECT pg_catalog.set_config Statement

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. taimusz=# SELECT pid, query_start, usename, left(query,7

Re: Logical Replication: SELECT pg_catalog.set_config Statement

=?UTF-8?Q?Hannes_K=c3=bchtreiber?= writes: > We have tried logical replication in a test-setup, and it appears to > work fine. > However, the following statement keeps running: > SELECT pg_catalog.set_config('search_path', '', false); What makes you think it "keeps running"? It looks to me lik