# General Workflow to Sync Data to ElasticSearch from PostGres

**URL:** <https://discuss.elastic.co/t/general-workflow-to-sync-data-to-elasticsearch-from-postgres/107095>\
**Category:** Elasticsearch\
**Created:** [November 9, 2017, 7:23pm UTC](https://discuss.elastic.co/t/general-workflow-to-sync-data-to-elasticsearch-from-postgres/107095 "2017-11-09T19:23:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akshay\_Deep\_Lamba](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@Akshay\_Deep\_Lamba](https://discuss.elastic.co/u/Akshay_Deep_Lamba)\
**Post date:** [November 9, 2017, 7:23pm UTC](https://discuss.elastic.co/t/general-workflow-to-sync-data-to-elasticsearch-from-postgres/107095/1 "2017-11-09T19:23:20Z")

</div>

Hello

I wanted to Real time or Near Real time sync Data from postgres to elastic Search... Below Are some Option I Tried Implementing :-

1. Followed [https://www.elastic.co/blog/logstash-jdbc-input-plugin](https://www.elastic.co/blog/logstash-jdbc-input-plugin) Tutorial and then created a cron job on Ubuntu .

2. Input data from Application Layer to Both the areas POSTgres and elasticsearch.

3. **--- Pls Suggest new and better options --**

Pls guide ..

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 9, 2017, 7:37pm UTC](https://discuss.elastic.co/t/general-workflow-to-sync-data-to-elasticsearch-from-postgres/107095/2 "2017-11-09T19:37:43Z")

</div>

I’d go for 2 as I explained there: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)

---

<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:** [December 7, 2017, 7:37pm UTC](https://discuss.elastic.co/t/general-workflow-to-sync-data-to-elasticsearch-from-postgres/107095/3 "2017-12-07T19:37:44Z")

</div>

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