Re: Logical Replication: SELECT pg_catalog.set_config Statement

=?UTF-8?Q?Hannes_K=c3=bchtreiber?= <h(dot)kuehtreiber(at)synedra(dot)com> 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 like the
replication client does that and then goes about its business:

> 2021-05-17 16:08:03.595 CEST -usztestlogrepsub(at)10(dot)139(dot)0(dot)41 <mailto:usztestlogrepsub(at)10(dot)139(dot)0(dot)41>: LOG: statement: SELECT pg_catalog.set_config('search_path', '', false);
> 2021-05-17 16:08:03.596 CEST -usztestlogrepsub(at)10(dot)139(dot)0(dot)41 <mailto:usztestlogrepsub(at)10(dot)139(dot)0(dot)41>: LOG: received replication command: IDENTIFY_SYSTEM

Admittedly, since you seem to have omitted the PID from your
log_line_prefix, it's hard to be 100% sure that these log entries
are from the same process. But I bet they are. The standard
walreceiver definitely does things this way.

In short, I think there's nothing to see here.

regards, tom lane