pgsql: Default monitoring roles

Default monitoring roles

Three nologin roles with non-overlapping privs are created by default
* pg_read_all_settings - read all GUCs.
* pg_read_all_stats - pg_stat_*, pg_database_size(), pg_tablespace_size()
* pg_stat_scan_tables - may lock/scan tables

Top level role - pg_monitor includes all of the above by default, plus others

Author: Dave Page
Reviewed-by: Stephen Frost, Robert Haas, Peter Eisentraut, Simon Riggs

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/25fff40798fc4ac11a241bfd9ab0c45c085e2212

Modified Files
--------------
contrib/pg_buffercache/Makefile                    |  5 +--
.../pg_buffercache/pg_buffercache--1.2--1.3.sql    |  7 +++++
contrib/pg_buffercache/pg_buffercache.control      |  2 +-
contrib/pg_freespacemap/Makefile                   |  4 +--
.../pg_freespacemap/pg_freespacemap--1.1--1.2.sql  |  7 +++++
contrib/pg_freespacemap/pg_freespacemap.control    |  2 +-
contrib/pg_stat_statements/Makefile                |  7 +++--
.../pg_stat_statements--1.4--1.5.sql               |  6 ++++
contrib/pg_stat_statements/pg_stat_statements.c    |  8 +++--
.../pg_stat_statements/pg_stat_statements.control  |  2 +-
contrib/pg_visibility/Makefile                     |  3 +-
contrib/pg_visibility/pg_visibility--1.1--1.2.sql  | 13 ++++++++
contrib/pg_visibility/pg_visibility.control        |  2 +-
contrib/pgrowlocks/pgrowlocks.c                    |  9 ++++--
contrib/pgstattuple/pgstattuple--1.4--1.5.sql      |  9 ++++++
doc/src/sgml/catalogs.sgml                         |  8 +++--
doc/src/sgml/func.sgml                             | 23 ++++++++------
doc/src/sgml/pgbuffercache.sgml                    |  5 +--
doc/src/sgml/pgfreespacemap.sgml                   |  5 +--
doc/src/sgml/pgrowlocks.sgml                       |  7 +++++
doc/src/sgml/pgstatstatements.sgml                 |  9 +++---
doc/src/sgml/pgstattuple.sgml                      |  3 +-
doc/src/sgml/pgvisibility.sgml                     |  5 ++-
doc/src/sgml/user-manag.sgml                       | 36 ++++++++++++++++++++++
src/backend/catalog/system_views.sql               |  6 ++++
src/backend/replication/walreceiver.c              |  3 +-
src/backend/utils/adt/dbsize.c                     | 20 ++++++++----
src/backend/utils/adt/pgstatfuncs.c                |  6 ++--
src/backend/utils/misc/guc.c                       | 21 ++++++++-----
src/include/catalog/pg_authid.h                    |  8 +++++
30 files changed, 196 insertions(+), 55 deletions(-)