How to import data from postgres to OpenSearch?

Plugins SQL
1

I want to connect OpenSearch with Postgres( or any other database) so that I can fetch my data in OpenSearch for indexing and other operations. Is there any documentation for that?

2

(Welcome @bashirahmad371!)

I don’t think there is any native capability to do that, however you might be able to do something similar to this article (changing the Elasticsearch output plugin to the OpenSearch output plugin). I haven’t personally tried this, but I’d be curious to know how well it works.

3

Have tried it and it works. Thanks.

1 Like
4

You can also use PGSync which is an open source tool that
also supports data denormalization.