# Please provide official logstash-output-jdbc plugin

**URL:** <https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259>\
**Category:** Logstash\
**Created:** [March 27, 2024, 10:33am UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259 "2024-03-27T10:33:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jasmine\_Blooms](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasmine_blooms/32/122027_2.png) [@Jasmine\_Blooms](https://discuss.elastic.co/u/Jasmine_Blooms)\
**Post date:** [March 27, 2024, 10:33am UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259/1 "2024-03-27T10:33:27Z")

</div>

Hi,  
My use case is to transfer data from Elasticsearch to Postgres. While exploring, I could find logstash-ouput-jdbc plugin([GitHub - theangryangel/logstash-output-jdbc: JDBC output for Logstash](https://github.com/theangryangel/logstash-output-jdbc?tab=readme-ov-file)) but it does not seem to be officially supported and there can be vulnerabilities and risks. Can someone please point to the official link in the Elasticsearch guide where i can find this plugin. Also, I am not sure how logstash-plugin list --group output provides me logstash-ouput-jdbc as one of the plugins if it is not supported officially.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/d/2dc260d012f9c5ac62bac9c7fed6e5f26d3e0a3f.jpeg)

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [March 27, 2024, 10:43am UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259/2 "2024-03-27T10:43:45Z")

</div>

Hi @Jasmine_Blooms,

Welcome back. This plugin is community created and not one that is actively maintained by Elastic [as per the support matrix](https://www.elastic.co/support/matrix#logstash_plugins).

Can you explain a bit more about how often you are looking to sync Elasticsearch data to Postgres. An alternative could be to write a Python script similar to that in [this StackOverflow thread](https://stackoverflow.com/questions/65507386/how-do-i-transfer-data-from-elastic-search-to-postgres) if you're not comfortable relying on this archived plugin.

Hope that helps!

---

<div class="post-metadata">

**Author:** ![Jasmine\_Blooms](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasmine_blooms/32/122027_2.png) [@Jasmine\_Blooms](https://discuss.elastic.co/u/Jasmine_Blooms)\
**Post date:** [March 27, 2024, 12:39pm UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259/3 "2024-03-27T12:39:09Z")

</div>

Hi,  
We are not looking to sync but transfer data completely as a one time activity.

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [March 27, 2024, 1:56pm UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259/4 "2024-03-27T13:56:20Z")

</div>

Thanks for confirming @Jasmine_Blooms. In that case you can either use the above plugin for a one-off operation. Or alternatively write a script in Python to extract the data (potentially in batches for a high volume index) and insert into Postgres.

Hope that helps!

---

<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:** [April 24, 2024, 1:57pm UTC](https://discuss.elastic.co/t/please-provide-official-logstash-output-jdbc-plugin/356259/5 "2024-04-24T13:57:07Z")

</div>

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