Voltar
-
Título
PostgreSQL cartridge requirements and server pre-configuration -
Descrição
Foglight for PostgreSQL is compatible with PostgreSQL version 9.1+ and managed database service versions using an equivalent or greater version, such as AWS Aurora/RDS and Microsoft Azure. However, some data may be missing from versions prior to 9.2, most notably I/O timing metric statistics, which are unavailable in those versions.
The agent may be run on a FglAM that is either local or remote to the PostgreSQL server.
More information on configuring a PostgreSQL DB user for monitoring can be found in the KB article 4229776 "PostgreSQL Agent User Permissions". -
Resolução
Several features of the server must be enabled in the server configuration file, typically the postgresql.conf file in a native instance or through the configuration UI in a hosted instance like AWS Aurora or RDS.Workload and I/O Metrics
The track_io_timing must be set to “on”.
More info is available here: https://www.postgresql.org/docs/current/static/runtime-config-statistics.html.Statement Monitoring
Installation of the pg_stat_statements module and creation of the extension in at least one database is required for statement tracking. Basic steps follow below. For more information on how to install this, refer to the relevant PostgreSQL documentation for your version.
- In postgresql.conf, set these sample properties. The pg_stat_statments module allows more advanced configuration, but these are the minimum required.
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
pg_stat_statements.track = all
More info on properties: https://www.postgresql.org/docs/current/static/pgstatstatements.html - Restart server
- In PSQL, pgAdmin, or another client program, execute this statement when connected to any database (postgres is fine): "CREATE EXTENSION pg_stat_statements;" The pg_stat_statements view should appear in DB's public schema. If the public schema does not exist, create this first.
- When configuring the Foglight for PostgreSQL agent properties, make sure to enable statement tracking and provide the database name where the extension was created.
- In postgresql.conf, set these sample properties. The pg_stat_statments module allows more advanced configuration, but these are the minimum required.
-
Informações adicionais
More information on configuring a PostgreSQL DB user for monitoring can be found in the PostgreSQL Agent User Permissions section of the Foglight for PostgreSQL user guide.