Logflare has experimental support for storing and querying log events to a PostgreSQL server. Ingested logs are directly inserted into tables, and each source maps to a Postgres table within a given schema.
PostgreSQL as a backend is only available for the V2 ingestion and currently has limited functionality.
Behavior and Configuration
On source creation, relevant migrations to create the source's table will be performed on the database.
The table schema is as follows:
id: The log event UUID.
timestamp: Unix microsecond, stored as
event_message: The provided or generated event message of the log event, stored as
body: A the processed log event, stored as
Where possible, storage and querying behavior will follow the BigQuery behavior
The following values can be provided to the backend:
string, required): A PostgreSQL connection string, for connecting to the server.
string, optional): The schema to scope all Logflare-related operations to.