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

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

Logical Replication: SELECT pg_catalog.set_config Statement

Hello everybody, not sure where to post this, general seems most appropriate. 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); It is issued by the user 'subs