Thread: Can database access for roles be different on the hot standby servervs the master server?

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?  Everything I have read so far about hot standby indicates that ANY change (such as create/drop role or grant/revoke) made on the master will propagate to the standby and that DDL statements cannot be run on the standby.

Thank you,

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089

t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com






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.