PostgreSQL Fleet integration

Elastic Stack Beats
,
1

Hi!

I installed postgresql integration, added path to the csvlog, however, the logs are not parsed properly. Also I updated postgresql configuration in accordance with this. The main problem is that postgresql query which should be in postgresql.log.query filed is in message field. In addition, I have 13 empty fields, however, I expect at least a few of them to have some data.
зображення

2

The issue is caused by postgresql logging itself. When you get the csv schema of a log, and add raw csv log in some cases you'll be able to see the inconsistencies in how the table is formed.