Can database access for roles be different on the hot standby server vs the master server?

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Can database access for roles be different on the hot standby server vs the master server?
Date: 2018-05-14 17:52:13
Message-ID: CADyzmyzt1JO5af=pnzLd2aywkZn=OtQV2CYkocZF52N_sUtVxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

--
<https://www.drivedominion.com/transform-your-vision/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message arvind chikne 2018-05-14 17:59:22 Master slave replication
Previous Message Don Seiler 2018-05-14 16:40:02 Re: Streaming Replication Networking Best Practices?