We run a master server and a hot standby server. Reporting users login to the standby server to run long queries. However, their login is also valid on the master server. Is it possible to prevent a user from logging in to the master server?
A statement like:
alter role newbie_business_analyst nologin;
Is replicated, so it would block logins on both servers.
I suspect that the only way to do this would be outside of the catalog. Either via firewall rules or pg_hba.conf (and the "reject" option)
David J.
