The pgsql
output plugin allows to send data from Fluent Bit to a PostgreSQL Database Server 9.4 or above. To store the data we use the JSON type so make sure that your PostgreSQL instance supports this type.
In your main configuration file add the following section:
Key
Description
Default
Host
Hostname of PostgreSQL instance
127.0.0.1
Port
PostgreSQL port
5432
Database
Database name to connect
fluentbit
Table
Table name where to store data
fluentbit
User
PostgreSQL username
current user
Password
Password of PostgreSLQ username
Timestamp_Key
Key to store the record timestamp
date