`session_replication_role` lost on reconnect

[mgolosova]

Hi,

Tried to compact some big table; after a few days the process was interrupted with:

[Thu Mar 21 12:03:52 2024] (my-db:my.table) Progress: 66%,  22145360 pages completed.
[Thu Mar 21 12:03:52 2024] (my-db:my.table) Connecting to database
[Thu Mar 21 12:03:52 2024] (my-db:my.table) SQL Error: ERROR:  The session_replication_role must be set to replica.

Should the role be set within db_connect?