When read replicas don't give you the functionality you need, try using Logical Replication.