Jesse, * jesse.waters@xxxxxxxxx (jesse.waters@xxxxxxxxx) wrote: > Could someone tell me what permission is required to > select * from pg_stat_replication; ? Currently, you're required to have superuser rights. > I like to setup a monitor to query database with minimal privileges necessary. I agree 110% and am actively working to fix exactly this issue. I hope to have a patch in the next day or so which will allow you to GRANT rights to such a monitor user which will allow that user to see all the contents of pg_stat_replication. One thing which would be really great is if you have time to test with the patch I'm working up (it's against 9.5, but this is strictly functionality testing and should be just in in a dev/test environment, I wouldn't suggest running 9.5 in production, of course!). Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
