When enabled, Grafana uses time_bucket in the $_timeGroup macro to display TimescaleDB specific aggregate functions in the query builder (only available in Grafana 5.3+).Ī lower limit for the $_interval and $_interval_ms variables. The maximum amount of time in seconds a connection may be reused, default 14400/4 hours (Grafana v5.4+).ĭetermines which functions are available in the query builder (only available in Grafana 5.3+).Ī time-series database built as a PostgreSQL extension. The maximum number of connections in the idle connection pool, default 2 (Grafana v5.4+). The maximum number of open connections to the database, default unlimited (Grafana v5.4+). Grafana v7.5+įile path or file content of SSL root certificate, client certificate and client key When SSL Mode is disabled, SSL Method and Auth Details would not be visible.ĭetermines whether the SSL Auth details will be configured as a file path or file content. The connection string for connecting to Postgres will not be correct and it may cause errors.ĭetermines whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server. The IP address/hostname and optional port of your PostgreSQL instance.
This is how you refer to the data source in panels and queries.ĭefault data source means that it will be pre-selected for new panels. To access PostgreSQL settings, hover your mouse over the Configuration (gear) icon, then click Data Sources, and then click the PostgreSQL data source. Only users with the organization admin role can add data sources.
#Aws postgresql table csv how to
For instructions about how to add a data source to Grafana, refer to Add a data source.
This topic explains options, variables, querying, and other options specific to this data source. Grafana ships with a built-in PostgreSQL data source plugin that allows you to query and visualize data from a PostgreSQL compatible database.
0 kommentar(er)
