git.postgresql.org Git - users/andresfreund/postgres.git/commit

projects / users / andresfreund / postgres.git / commit

author	Simon Riggs <simon@2ndQuadrant.com>
	Thu, 30 Mar 2017 18:18:53 +0000 (14:18 -0400)
committer	Simon Riggs <simon@2ndQuadrant.com>
	Thu, 30 Mar 2017 18:18:53 +0000 (14:18 -0400)
commit	25fff40798fc4ac11a241bfd9ab0c45c085e2212
tree	3c2e3eb741f814bba8eaa593d17811b86b8d2a00	tree
parent	e984ef5861df4bc9733b36271d05763e82de7c04	commit \| diff

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

30 files changed:

contrib/pg_buffercache/Makefile		diff \| blob \| blame \| history
contrib/pg_buffercache/pg_buffercache--1.2--1.3.sql	[new file with mode: 0644]	blob
contrib/pg_buffercache/pg_buffercache.control		diff \| blob \| blame \| history
contrib/pg_freespacemap/Makefile		diff \| blob \| blame \| history
contrib/pg_freespacemap/pg_freespacemap--1.1--1.2.sql	[new file with mode: 0644]	blob
contrib/pg_freespacemap/pg_freespacemap.control		diff \| blob \| blame \| history
contrib/pg_stat_statements/Makefile		diff \| blob \| blame \| history
contrib/pg_stat_statements/pg_stat_statements--1.4--1.5.sql	[new file with mode: 0644]	blob
contrib/pg_stat_statements/pg_stat_statements.c		diff \| blob \| blame \| history
contrib/pg_stat_statements/pg_stat_statements.control		diff \| blob \| blame \| history
contrib/pg_visibility/Makefile		diff \| blob \| blame \| history
contrib/pg_visibility/pg_visibility--1.1--1.2.sql	[new file with mode: 0644]	blob
contrib/pg_visibility/pg_visibility.control		diff \| blob \| blame \| history
contrib/pgrowlocks/pgrowlocks.c		diff \| blob \| blame \| history
contrib/pgstattuple/pgstattuple--1.4--1.5.sql		diff \| blob \| blame \| history
doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/func.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgbuffercache.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgfreespacemap.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgrowlocks.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgstatstatements.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgstattuple.sgml		diff \| blob \| blame \| history
doc/src/sgml/pgvisibility.sgml		diff \| blob \| blame \| history
doc/src/sgml/user-manag.sgml		diff \| blob \| blame \| history
src/backend/catalog/system_views.sql		diff \| blob \| blame \| history
src/backend/replication/walreceiver.c		diff \| blob \| blame \| history
src/backend/utils/adt/dbsize.c		diff \| blob \| blame \| history
src/backend/utils/adt/pgstatfuncs.c		diff \| blob \| blame \| history
src/backend/utils/misc/guc.c		diff \| blob \| blame \| history
src/include/catalog/pg_authid.h		diff \| blob \| blame \| history

Andres' PG stuff

RSS Atom