Can datahub extracts lineage automatically from redshift, postgres, mongo db and S3?

Redshift / postgres - yes, and mongodb / s3 - no. You can get more information under our integrations docs here : https://datahubproject.io/integrations