Re: Can database access for roles be different on the hot standbyserver vs the master server?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can database access for roles be different on the hot standbyserver vs the master server?
Дата
Msg-id CAKFQuwZFLYcBTnJTykFciLhtB2Yf3twkACNkcUvbr5Cb-g49=w@mail.gmail.com
обсуждение исходный текст
Ответ на Can database access for roles be different on the hot standby servervs the master server?  (Mark Steben <mark.steben@drivedominion.com>)
Список pgsql-admin
Дерево обсуждения
On Monday, May 14, 2018, Mark Steben <mark.steben@drivedominion.com> wrote:
Hello,

I just implemented two instances of hot standby psql databases on a server for the purpose of developer queries and reports.  The primary servers are our production servers.  Is it possible to revoke the access by developers on production while giving them read access on the standby?

Setup the pg_hba.conf file to prevent connection on the master?  Said file isn't part of the replication.

David J.

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

Предыдущее
От: arvind chikne
Дата:
Сообщение: Master slave replication
Следующее
От: Johannes Truschnigg
Дата:
Сообщение: Re: Streaming Replication Networking Best Practices?