yeah i have this setup. pain point is syncing between them, still haven't figured out a good pattern. just running a cron overnight which feels dumb but works
In ClickHouse Cloud, you have ClickPipes which is a simpler/managed manifesation of PeerDB https://clickhouse.com/cloud/clickpipes/postgres-cdc-connect...