Re: [HACKERS] restrict global access to be readonly

2015-02-17 Thread happy times
?6?9Jim Nasby writes: On 2/14/15 3:14 PM, Robert Haas wrote: Although I like the idea, it's not clear to me how to implement it. Throw an error in AssignTransactionId/GetNewTransactionId? A whole lot depends on what you choose to mean by read only. If it ?6?9means the same thing as all

[HACKERS] restrict global access to be readonly

2015-02-13 Thread happy times
Hi PG Developers, I didn’t find any convenient way to restrict access to PostgreSQL databases to be read-only for all users. I need it in following scenarios: A) Planned switch-over from master to slave. We want to minimize impact within the planned switch-overs. So during the process we