Postgresql logs are not seen


(VISHNU) #1

Hi,
Following is my platform,
OS - CentOS 7.4
ES - 6.2
LS - 6.2
Kibana - 6.2
Filebeat - 6.2

Following is my postgresql module configuration file,
> - module: postgresql
> # All logs
> log:
> enabled: true
>
> # Set custom paths for the log files. If left empty,
> # Filebeat will choose the paths depending on your OS.
> var.paths: ["/opt/postgresql/data/logs/pg95/.log"]

I am not able to view the postgres dashboard view from kibana, :frowning:
The psql version I am using is postgresql 9.5 by OpenSCG (BigSQL).

Thanks In advance
Vishnu


(Harsh Bajaj) #2

Hi,

could you please provide bit more information about your use case so that i can provide the solution.

Please clear this point are you able to see logs but not able to see sample dashboard or you are not able see logs in kibana?

If you are not able see the logs in kibana then please share your filebeat logs and config file to understand where is the problem.

Regards,


(Noémi Ványi) #3

Are you sure your path configuration is correct? Isn't it supposed to be var.paths: ["/opt/postgresql/data/logs/pg95/*.log"] instead of var.paths: ["/opt/postgresql/data/logs/pg95/.log"]?


(VISHNU) #4

Hi,
Its been formatted by the editor. Actually its as followes,
["/opt/postgresql/data/logs/pg95/<>.log<>"]

Thanks
Vishnu


(system) #5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.