Thread: Can database access for roles be different on the hot standby servervs the master server?
Can database access for roles be different on the hot standby servervs the master server?
From
Mark Steben
Date:
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
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
Re: Can database access for roles be different on the hot standbyserver vs the master server?
From
"David G. Johnston"
Date:
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.