I have a primary server, with a secondary replicating it.
I want to change a role from LOGIN to NOLOGIN.
I can do this easily on the primary, but the change doesn't replicate to the secondary, and I can't change it on the secondary:
postgres=# ALTER ROLE myrolename WITH NOLOGIN; ERROR: cannot execute ALTER ROLE in a read-only transaction
Is there an easy solution to this?