I'd think using built-in replication (e.g. PostgreSQL 'logical replication') for 'dual writing' should mostly avoid inconsistencies between the two versions of the DB, no?
The way I've done this involves logical replication also: https://news.ycombinator.com/item?id=31087197