How to Split Read and Write Traffic Safely in a Patroni Cluster

Expose separate Patroni-aware PostgreSQL write and read endpoints, enforce role checks, and keep replica lag and read-after-write behavior explicit.