Tolu Aina

- Can you please try with the version on the main branch? - Please note: this does not have a lot of tests yet but I was able to reproduce...

Are you suggesting that you are still seeing this query below: ``` SELECT count(*) AS count_1 FROM PG_LOGICAL_SLOT_PEEK_CHANGES('coverage_street', NULL, NULL) WHERE CAST(CAST(xid AS TEXT) AS BIGINT) >= 12096230 AND CAST(CAST(xid...

- I figured the `MAX(lsn)` would be an issue from the original report. - The latest changes in main removes the `MAX(lsn)` completely

I feel there are multiple things going on here. Is anyone able to reliably reproduce this? `sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected`

all done and thanks for pointing this out. A new version has been published.

Try the polling option. This might satisfy your requirements as it runs a single iteration/cycle and might be more suited for cron

Just a quick follow-up: you can now run pgsync in polling-only mode. In this mode it ignores triggers and replication logs, continuously polling for changes instead. It’s not exactly a...

Apologies for the delay. Can you share your schema either publicly or privately? The schema can be split based on database/index pair. How large are we talking about here?

Thanks for that. sorry for the dealy. All fixed

this is now included in 3.2.1 release [here](https://pypi.org/project/pgsync/)