> then just disable the replication slot when you want to make local changes without affecting the primary

This would be all the time, ie. in my local dev, I’d like to have an up to date (daily is ok), copy of the source db that I can modify anytime, but that everyday will sync with the source, without having to fully rebuild indices

How would you go about managing/coordinating that?