Integrating postgresql with elk


(Gokul Kathirvel) #1

Am new to elk,how can i integrate my postgres db with elastic search.. all have said about jdbc , i did not understand properly.. any body have suggesstion??


#2

By using logstash (input: jdbc), you'll be able to ingest your postgres data in elastic.

https://www.elastic.co/guide/en/logstash/current/getting-started-with-logstash.html

https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html


(David Pilato) #3

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.


(system) #4

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