Postgres Pro
Downloads
Home   >   mailing lists

Re: Can database access for roles be different on the hot standbyserver vs the master server? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Can database access for roles be different on the hot standbyserver vs the master server?
Date
Msg-id CAKFQuwZFLYcBTnJTykFciLhtB2Yf3twkACNkcUvbr5Cb-g49=w@mail.gmail.com
Whole thread Raw
In response to Can database access for roles be different on the hot standby servervs the master server?  (Mark Steben <mark.steben@drivedominion.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: arvind chikne
Date:
Subject: Master slave replication
Next
From: Johannes Truschnigg
Date:
Subject: Re: Streaming Replication Networking Best Practices?