Re: Allow login on slave only

On Fri, Dec 16, 2016 at 9:17 AM, Andomar <andomar(at)aule(dot)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.

>