Integrating PostgreSQL with Elasticsearch and Kibana

From: rahulk <rahulk1306(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Integrating PostgreSQL with Elasticsearch and Kibana
Date: 2014-11-11 06:05:27
Message-ID: 1415685927723-5826459.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have source input which stores data in PostgreSQL database in JSON format.
I want to perform the analytical operation on data present in PostgreSQL and
visualize the results of operations.

I have found one open source analytical tool called Kibana (integrated with
elasticsearch) which will visualize the data.
http://www.elasticsearch.org/overview/kibana/

we can provide data present in PostgreSQL to elastic search through use of
jdbc-river
https://github.com/jprante/elasticsearch-river-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL

I am trying to integrate PostgreSQL, elasticsearch and Kibana to perform
analytical operations and visualize data.

Anybody tried something like that, your views and suggestion will be useful.
Thanks in advance

Regards,
Rahul Khengare

--
View this message in context: http://postgresql.nabble.com/Integrating-PostgreSQL-with-Elasticsearch-and-Kibana-tp5826459.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Browse pgsql-general by date

  From Date Subject
Next Message avpro avpro 2014-11-11 06:38:11 trigger Before or After
Previous Message Ilya Ashchepkov 2014-11-11 03:09:05 Re: justify_interval: days in year