I’m trying to unload a table data from postgres database into amazon s3.
I’m aware that redshift has a option of unload into s3 – Since redshift is a postgres database, I tried using the same command in my postgres database but was unsuccesful.
Can someone help me with unloading table data from postgres into s3 periodically ?
Redshift is based on a PostgreSQL clone but there’s not 1-1 feature correspondence. If you want to load data from a PostgreSQL DB to Redshift, through S3, you should: