The File Log Monitor Agent fails to monitor PostgreSQL logs because the time stamp of the records are in a different time zone than the server; for example the log record uses GMT time zone while the server itself is setup for MST time zone.
From the agent logs it can be confirmed that log records are discarded:
2022-06-16 14:32:34.062 VERBOSE [ActivityService-218-0[149]-7] com.dell.foglight.infrastructure.actions.logmonitor.file.FileLogTopologyCreationAction - Discarding 1 record(s) in [host]/example/path/postgres.log timestamped at Thu Jun 16 00:37:00 EST 2022 or older, because they are too old and will be rejected anyway.
WORKAROUND
Align the time zones for the monitored environment:
Set the target server time zone to match the PostgreSQL logs time zone.
or
Set the PostgreSQL log time zone to match the target server time zone.
STATUS
Enhancement request FOG-1137 has been submitted to Development for consideration in a future release of Foglight Cartridge for Infrastructure.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center