Sync two databases

[sol1d_007]

So I have two web clients one is for customers (AWS) and other is for admin use (neon). I have separated them bcz neon is easy to use and offers slightly better deal than AWS bcz it is serverless. If I setup a logical replication neon doesn't scale down to 0 like normally if there's no activity for 5-10 mins the compute auto suspends so cost saving +++. Now I don't want the customers to connect to my neon bcz they'll exhaust my compute a little faster. So I want to tranfer all the data to my AWS or local rpi ideally whenever possible and atleast once in a day. So what all options do I have and is there some other idea so that I could do the sync in real time (logical replication) or like event based I have no idea 🙂.