Header image

Syncing PostgreSQL Data to Elasticsearch using Logstash in Ubuntu 20.04

July 17, 2020Uncategorized

If logstash/elasticsearch in not installed refer https://flapicon.io/installation-of-elasticsearch-logstash-and-kibana-elk-stack-on-ubuntu-20-04/ Step 1: Install JDBC Plugin Step 2: Download JDBC library Step 3: Edit config to use escape characters in our postgresql queries in logstash. Add/Edit the following config Step 4: Create logstash pipeline file (Table name is institutes, therefore institutesync.conf) Add the following content Note username and password …

Read more