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/>
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? |