Connecting to Postgresql from elasticsearch

I'm new to elastic search..I need to know whether I can send data from database(Postgresql) to elastic search directly without using logstash and beats.if there any way..pls suggest me..thanks in advance.

There is no direct way, you need a process that will pull data from postgres and put it into Elasticsearch.

Can you suggest some way to send data to elastic search from postgres

I'm not a logstash expert (please ask on the logstash forums if you need more info) but Logstash has a JDBC input plugin (https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) and an Elasticsearch output plugin (https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.html) so this should do the work. Alternatively this should also be relatively easy to write with your favourite programming language.

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

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