how are people syncing these? i just have a cron job running overnight and it feels dumb. tried debezium but it was overkill

Depends on your use case but if you want to avoid the syncing problem altogether you can federate queries to Postgres either via the native Postgres connector or over a JDBC bridge