PostgreSQL Output Plugin
Powerful performance with an easy integration, powered by Telegraf, the open source data connector built by InfluxData.
5B+
Telegraf downloads
#1
Time series database
Source: DB Engines
1B+
Downloads of InfluxDB
2,800+
Contributors
Table of Contents
Powerful Performance, Limitless Scale
Collect, organize, and act on massive volumes of high-velocity data. Any data is more valuable when you think of it as time series data. with InfluxDB, the #1 time series platform built to scale with Telegraf.
See Ways to Get Started
PostgreSQL is an open-source relational database with an emphasis on SQL compliance. PostgreSQL allows users to store large and sophisticated data sets thanks to its many post-relational concepts like in-database functions and user-defined datatypes. PostgreSQL supports different data types in the same data tables, and querying all those different data types simultaneously. This makes it a very powerful and flexible database solution. PostgreSQL also offers robust security to ensure all this data remains secure.
Why use the PostgreSQL Output Plugin?
The PostgreSQL Output Plugin allows you to send metrics stored in InfluxDB to any PostgreSQL database or PostgreSQL-compatible system. The plugin manages the schema of your data and automatically updates any missing columns to ensure consistency across your application or system.
How to use the PostgreSQL Output Telegraf Plugin
By default, the plugin does not utilize concurrency, but you can configure concurrency for increased throughput.
The plugin maps InfluxDB data types to the following PostgreSQL types by default:
| Influx | PostgreSQL |
|---|---|
| float | double precision |
| integer | bigint |
| uinteger | numeric* |
| string | text |
| boolean | boolean |
| unix timestamp | timestamp |
The plugin uses templates to give users complete control over their data.
The plugin also provides error handling options. There are different behaviors for temporary and permanent errors.
Powerful Performance, Limitless Scale
Collect, organize, and act on massive volumes of high-velocity data. Any data is more valuable when you think of it as time series data. with InfluxDB, the #1 time series platform built to scale with Telegraf.
See Ways to Get Started
