> On Mar 31, 2020, at 9:08 AM, Jeff Ross <[email protected]> wrote: > > FATAL: terminating connection due to idle-in-transaction timeout
Well, this sounds like *a* potential issue (not necessarily *the* issue). What do you have the idle_in_transaction_session_timeout parameter set to? If it’s particularly low, (read: lower than some rate of changes) you could end up in a situation where the CTL connection terminates like you display, and then bets are off. I would not expect this to be a persistent issue (i.e., a Bucardo restart should reestablish these connections and pick up where it left off). If you need the idle_in_transaction_session_timeout behavior, at the very least, you could alter the “bucardo” user to disable this GUC for that user. HTH, David -- David Christensen Senior Software and Database Engineer End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
