Grant user SELECT on pg_stat_database?

396 views
Skip to first unread message

Chris Miller

unread,
Jun 13, 2014, 12:44:17 AM6/13/14
to puppet...@googlegroups.com
How do I grant a user SELECT privileges on the pg_stat_database catalog? Using the normal postgresql::server::database_grant approach just returns: "'ERROR: database "pg_stat_database" does not exist"

-Chris

Chris

unread,
Jun 16, 2014, 6:45:03 PM6/16/14
to puppet...@googlegroups.com
pg_stat_database isn't a database, it's a view inside *each* postgres
database (ie the stats in there are not for the entire cluster).

--
Postgresql & php tutorials
http://www.designmagick.com/

Reply all
Reply to author
Forward
0 new messages