CODEWITHSUNDEEP
javapostgresqlelasticsearch
Grigor
Grigor

Reputation: 58

How can I migrate PostgreSQL database to the Elastic index?

I have a project which uses PostgreSQL, and Elastic for fast search. Can I make the database data go to the Elastic index, but not all columns? How can I automate this process with every change in the database?

I tried to do this manually, but there are some update functions so it is almost impossible to do manually.

Upvotes: 0

Views: 1680

Answers (1)

Ben M. Ward
Ben M. Ward

Reputation: 85

You could use the Logstash JDBC plugin to run a query on your Postgresql database, and feed that data into Elasticsearch.

More information about Logstash JDBC input plugin can be found documented here: https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html

Upvotes: 3

Related Questions