Hi Dave, The patch failed applied...
patch -p1 < /home/vagrant/pg_monitor.diff patching file contrib/pg_buffercache/Makefile patching file contrib/pg_buffercache/pg_buffercache--1.2--1.3.sql patching file contrib/pg_buffercache/pg_buffercache.control patching file contrib/pg_freespacemap/Makefile patching file contrib/pg_freespacemap/pg_freespacemap--1.1--1.2.sql patching file contrib/pg_freespacemap/pg_freespacemap.control patching file contrib/pg_stat_statements/Makefile patching file contrib/pg_stat_statements/pg_stat_statements--1.4--1.5.sql patching file contrib/pg_stat_statements/pg_stat_statements.c patching file contrib/pg_stat_statements/pg_stat_statements.control patching file contrib/pg_visibility/Makefile Hunk #1 succeeded at 4 with fuzz 1. patching file contrib/pg_visibility/pg_visibility--1.1--1.2.sql patching file contrib/pg_visibility/pg_visibility.control patching file contrib/pgrowlocks/pgrowlocks.c patching file contrib/pgstattuple/pgstattuple--1.4--1.5.sql patching file doc/src/sgml/catalogs.sgml Hunk #1 succeeded at 10027 (offset 11 lines). patching file doc/src/sgml/func.sgml Hunk #1 succeeded at 19364 (offset 311 lines). Hunk #2 succeeded at 19648 (offset 311 lines). patching file doc/src/sgml/pgbuffercache.sgml patching file doc/src/sgml/pgfreespacemap.sgml patching file doc/src/sgml/pgrowlocks.sgml patching file doc/src/sgml/pgstatstatements.sgml patching file doc/src/sgml/pgstattuple.sgml patching file doc/src/sgml/pgvisibility.sgml patching file doc/src/sgml/user-manag.sgml patching file src/backend/catalog/system_views.sql Hunk #1 FAILED at 1099. 1 out of 1 hunk FAILED -- saving rejects to file src/backend/catalog/system_views.sql.rej patching file src/backend/replication/walreceiver.c patching file src/backend/utils/adt/dbsize.c Hunk #1 succeeded at 17 (offset -1 lines). Hunk #2 succeeded at 89 (offset -1 lines). Hunk #3 succeeded at 179 (offset -1 lines). patching file src/backend/utils/adt/pgstatfuncs.c patching file src/backend/utils/misc/guc.c Hunk #2 succeeded at 6678 (offset 10 lines). Hunk #3 succeeded at 6728 (offset 10 lines). Hunk #4 succeeded at 8021 (offset 10 lines). Hunk #5 succeeded at 8053 (offset 10 lines). patching file src/include/catalog/pg_authid.h Reject file contents... cat src/backend/catalog/system_views.sql.rej --- src/backend/catalog/system_views.sql +++ src/backend/catalog/system_views.sql @@ -1099,3 +1099,7 @@ REVOKE EXECUTE ON FUNCTION pg_ls_logdir() FROM public; REVOKE EXECUTE ON FUNCTION pg_ls_waldir() FROM public; +GRANT EXECUTE ON FUNCTION pg_ls_logdir() TO pg_monitor; +GRANT EXECUTE ON FUNCTION pg_ls_waldir() TO pg_monitor; + +GRANT pg_read_all_gucs TO pg_monitor; The new status of this patch is: Waiting on Author -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers