Disconnect user from

[Igor Miranda]

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

Disconnect user from replica

[Igor Miranda]

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