Dual writing has huge downsides: namely you're now moving consistency into the application, and it's almost guaranteed that the databases won't match in any interesting application.
The way I've done this involves logical replication also: https://news.ycombinator.com/item?id=31087197