Re: [GENERAL] Allow login on slave only

Поиск
Список
Период
Сортировка
От Joseph Kregloh
Тема Re: [GENERAL] Allow login on slave only
Дата
Msg-id CAAW2xfeba05fR8NBToCEVx75vuX-aCK7+g_GB06Cr=-7415TiA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Allow login on slave only  ("Andomar" <andomar@aule.net>)
Список pgsql-general
Дерево обсуждения
You can leave authentication to something else. For example authenticate the users by having them connect to pgBouncer first.

-Joseph

On Fri, Dec 16, 2016 at 11:17 AM, Andomar <andomar@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.

 

Thanks,

Andomar


В списке pgsql-general по дате отправления:

Предыдущее
От: Poul Kristensen
Дата:
Сообщение: [GENERAL] pg_hba.conf debugging or logging when using ldag to authenticate
Следующее
От: Christophe Escobar
Дата:
Сообщение: [GENERAL] Avoid using index scan backward when limit order desc