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

Поиск
Список
Период
Сортировка
От Mark Steben
Тема Can database access for roles be different on the hot standby servervs the master server?
Дата
Msg-id CADyzmyzt1JO5af=pnzLd2aywkZn=OtQV2CYkocZF52N_sUtVxQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can database access for roles be different on the hot standbyserver vs the master server?
Список 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 | 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






В списке pgsql-admin по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: Streaming Replication Networking Best Practices?
Следующее
От: arvind chikne
Дата:
Сообщение: Master slave replication