Comment by tomatofrank

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