1/8/2023 0 Comments Postgresql databaseThe pg_stat_activity view is a system view containing information about database server processes activity. Limited monitoring queries only the pg_stat_activity view. The monitoring mode you choose determines what configuration steps are required. Task 2: Configure PostgreSQL database instances for DPA monitoring Determine which monitoring mode to useĭPA offers two modes of monitoring PostgreSQL database instances. GRANT SELECT ON dpa_schema.pg_stat_statements TO dpa_user GRANT USAGE ON SCHEMA dpa_schema TO dpa_user To grant access, create a dedicated DPA schema and make a synonym of pg_stat_statements in it:ĬREATE VIEW dpa_schema.pg_stat_statements AS SELECT * FROM enterprisedb.pg_stat_statements If you are monitoring EDB Postgres version 10, you must give the DPA monitoring user access to the pg_stat_statements view.įor EDB Postgres version 10, granting the the pg_read_all_stats role does not give the DPA monitoring user access to the view pg_stat_statements. x in Amazon RDS and Amazon Aurora deployments:įor PostgreSQL 9.6. x in self-managed deployments:įor PostgreSQL 9.6. GRANT pg_read_all_stats, pg_read_all_settings, pg_signal_backend TO dpa_user įor PostgreSQL 9.6. For earlier versions, the SUPERUSER privilege is required. There are dedicated pg_read_all_stats and pg_read_all_settings roles in PostgreSQL 10 and later. Where dpa_user is the user name and password is the password. Run the following SQL statement on the PostgreSQL database instance to create the DPA monitoring user:ĬREATE USER dpa_user WITH ENCRYPTED PASSWORD ' password' Make sure the monitoring user will not cause load on the monitored instance. The user will have the necessary rights and privileges.ĭPA ignores data on the monitored database instance from the monitoring user. Use these instructions to manually create the user that DPA uses to monitor a PostgreSQL database instance. You must configure each PostgreSQL database instance, as described below. If you need to change the default tablespace, register the instance using mass registration. You cannot change the default tablespace in the Register Instance Wizard. If the DPA repository is an Oracle database, DPA stores performance data for monitored PostgreSQL database instances in the default tablespace of the repository user. Create the monitoring user manually, as described below. You cannot use the wizard to create the DPA monitoring user. Registering a PostgreSQL database instance is slightly different than registering other types of monitored database instances: You can also use mass registration to registrations to register multiple database instances, or you can register database instances using scripts that call the DPA API. This procedure includes the following deployment types: Register a PostgreSQL database instance and prepare for monitoringĬomplete the following tasks to register a PostgreSQL database instance for monitoring with DPA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |