Did you consider postgres foreign data wrapper functionality? With that you’d not need to sync data in the first place.