On Fri, Dec 16, 2016 at 9:17 AM, Andomar <ando...@aule.net> wrote: > 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) https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html David J. >
