This message was deleted.

There is a

sql

input source in native batch ingestion, which supports ingestion from the

postgres

database. You can use that to ingest the data from the existing postgres database to druid. More info can be found here: https://druid.apache.org/docs/latest/ingestion/native-batch-input-sources.html#sql-input-source.

The simpler approach is to dump the data from Postgres into file and then do a batch ingestion to druid

Thank Laksh and Vijay,, I will check this . on a side note.. we want this process to be continuous streaming , not one time.

In case you want this to be continuous then both of the above approaches won’t work. Either you’ll have to schedule a job which ingests that new data (based on some filter, like time) or ingest the postgres data to something like Kafka and then run a continuous streaming ingestion from there.