Thread: Disconnect user from replica

Disconnect user from replica

From
Igor Miranda
Date:

Hello,

I have a PostgreSQL cluster on a read replication topology and I want to know if it's possible to send commands to all replicas from the primary instance (in this particular case, it'd be to disconnect one user from all replicas).
I know it is possible to log into each and every replica and issue pg_terminate_backend, but this solution isn't feasible in our case...
Any idea would help a lot! Regards

--
Att,
Ajudici
Igor Fernandes Miranda
Desenvolvedor |Ajudici
Tel.: (61) 992492816