# Postgresql to Elastic - River Plugin replacement

**URL:** <https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283>\
**Category:** Elasticsearch\
**Created:** [September 14, 2015, 10:36pm UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283 "2015-09-14T22:36:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kiranpatil](https://avatars.discourse-cdn.com/v4/letter/k/9fc348/32.png) [@Kiranpatil](https://discuss.elastic.co/u/Kiranpatil)\
**Post date:** [September 14, 2015, 10:36pm UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283/1 "2015-09-14T22:36:13Z")

</div>

Hi,

I want to push Postgresql data to ElasticSearch on every change. This needs to be done in (near) realtime as my app search is relying on ES.

As River plugin is deprecated, what are the other options/best practices to do such things?

Thanks!  
Kiran

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 14, 2015, 10:48pm UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283/2 "2015-09-14T22:48:17Z")

</div>

[https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) is what you want

---

<div class="post-metadata">

**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:** [September 15, 2015, 7:49am UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283/3 "2015-09-15T07:49:32Z")

</div>

You can use JDBC importer

> **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc)**
>
> elasticsearch-jdbc - JDBC importer for Elasticsearch

---

<div class="post-metadata">

**Author:** ![Kiranpatil](https://avatars.discourse-cdn.com/v4/letter/k/9fc348/32.png) [@Kiranpatil](https://discuss.elastic.co/u/Kiranpatil)\
**Post date:** [September 15, 2015, 9:01pm UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283/4 "2015-09-15T21:01:52Z")

</div>

Thanks! This works...

---

<div class="post-metadata">

**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:50pm UTC](https://discuss.elastic.co/t/postgresql-to-elastic-river-plugin-replacement/29283/6 "2017-07-05T23:50:15Z")

</div>