# How to connect PostgreSQL Database using elastic Search? **URL:** \ **Category:** Elasticsearch\ **Created:** [December 8, 2015, 1:06pm UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636 "2015-12-08T13:06:01Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Rajnikant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajnikant/32/6490_2.png) [@Rajnikant](https://discuss.elastic.co/u/Rajnikant)\ **Post date:** [December 8, 2015, 1:06pm UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/1 "2015-12-08T13:06:01Z")
I want to connect PostgreSQL database using Elasticsearch and use directly url of Elasticsearch in to js file. ---
**Author:** ![Thollon\_Arthur](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thollon_arthur/32/46064_2.png) [@Thollon\_Arthur](https://discuss.elastic.co/u/Thollon_Arthur)\ **Post date:** [December 8, 2015, 2:43pm UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/2 "2015-12-08T14:43:40Z")
Hey! We are currently using Jprante/elasticsearch-jdbc which is really useful to get data from postgreSQL to Elasticsearch (through SQL queries) and the javascript client for elasticsearch elasticsearch.js to call elasticsearch from js. This solution is really nice, and works with the newest version of elasticsearch. PS: Thanks to Jprante btw. ---
**Author:** ![Rajnikant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajnikant/32/6490_2.png) [@Rajnikant](https://discuss.elastic.co/u/Rajnikant)\ **Post date:** [December 9, 2015, 7:42am UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/3 "2015-12-09T07:42:36Z")
Thank you for Quick Reply. I already done this thing but i get error when i was connect to database. And when i was searching about error thin i found river is not working on elasticsearch version 2.1. pls help me out. ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [December 9, 2015, 7:55am UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/4 "2015-12-09T07:55:49Z")
@Rajnikant JDBC importer for Elasticsearch 2.1 is not a river. It's a standalone application. You can open your issue at [https://github.com/jprante/elasticsearch-jdbc/issues](https://github.com/jprante/elasticsearch-jdbc/issues) if you like. ---
**Author:** ![Rajnikant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajnikant/32/6490_2.png) [@Rajnikant](https://discuss.elastic.co/u/Rajnikant)\ **Post date:** [December 9, 2015, 9:38am UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/5 "2015-12-09T09:38:49Z")
@jprante thank you. i was open new issue on github. please help me. ---
**Author:** ![Rajnikant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajnikant/32/6490_2.png) [@Rajnikant](https://discuss.elastic.co/u/Rajnikant)\ **Post date:** [December 10, 2015, 8:06am UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/6 "2015-12-10T08:06:29Z")
@jprante Data is successfully imported but when i was checking in to elastic search then i did not get anything. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 11:32pm UTC](https://discuss.elastic.co/t/how-to-connect-postgresql-database-using-elastic-search/36636/7 "2017-07-05T23:32:08Z")