Hello Everyone, I have a beginner question regarding a context in which we have to index a PostgreSQL database with Elastic. Is it required to use an intermediary solution between PostgreSQL and Elastic ? If so what are the best practices to adopt regarding the intermediary solution between Postgr…

Bienvenue Lucien ! :slight_smile: You need to send your existing data to Elasticsearch. That means: Read from the database (SELECT * from TABLE) Convert each record to a JSON Document Send the json document to Elasticsearch, preferably using the _bulk API. Logstash can help for that. But I'd re…

Discuss the Elastic Stack

Best practices to handle jdbc (Postgresql) contents?

Elastic Stack Elasticsearch

lucien.guillermin (Lucien GUILLERMIN) October 18, 2021, 2:24pm 7

Thank you so much for this detailed feedback

Topic		Replies	Views
Integrating postgresql with elk Elasticsearch	3	4896	July 31, 2018
Connecting to Postgresql from elasticsearch Elasticsearch	5	4763	April 11, 2018
Postgres to elastic Elasticsearch	2	328	August 21, 2018
Ingest data from Relational DB to Elasticsearch Elasticsearch	10	1733	September 30, 2022
How to integrate Elasticsearch and PgSQL? Elasticsearch	2	308	April 5, 2019

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Best practices to handle jdbc (Postgresql) contents?

Related topics