Push PostgresDB Server complete data to logstash

[kaushalshriyan]

Hi,

I have run /usr/share/logstash/bin/logstash-plugin install logstash-input-jdbc after following https://www.elastic.co/blog/logstash-jdbc-input-plugin. Is there a way to import complete Postgres Database server data to logstash?

PostgresDB Server data -> logstash -> Elasticsearch

Below reference mentions about multiple_sql_statements.

https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_configuring_multiple_sql_statements

Thanks in Advance.

Best Regards,

[magnusbaeck (Magnus Bäck)]

The documentation you link to describe the procedure pretty well so I'm not sure what your question is about.

Are you sure you want to bulk-import a complete database? Elasticsearch doesn't support joins so a normalized data schema probably won't be optimal.