Just a bit more info: Kicking the sync doesn't seem to do anything. When it's in this idle state, there's an orphan backend in PostgreSQL for bucardo, in idle-in-transaction, doing a SELECT on a sequence.
> On Oct 31, 2018, at 08:26, Christophe Pettus <[email protected]> wrote: > > Version 5.4.1. > > We have a delta sync running between two fairly large databases. When > Bucardo starts, it correctly processes the deltas and catches up, and then > stops. The sync status remains in "Begin txn", and it doesn't continue to > process the delta queue. If I restart Bucardo, it then goes through the > queue correctly. Any thoughts about what might be going on here? > > -- > -- Christophe Pettus > [email protected] > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general -- -- Christophe Pettus [email protected] _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
