Hey friends! I am a newbie to DE coming from Analytics. Going through ‘Data Stacks for Fun and Non-Profit’ and trying to run elt workflow right now with:

meltano elt tap-spreadsheets-anywhere target-postgres

but i got this error:

psycopg2.OperationalError: FATAL:  password authentication failed for user "postgres"
target-postgres           | 
meltano                   | Loading failed (1): (see above)
meltano                   | ELT could not be completed: Loader failed
ELT could not be completed: Loader failed

i had the same error when I was trying to run:

meltano add loader target-postgres --variant meltano

and unblocked via going to my pgcli and typing in:

grant all privileges on database ds4fnp to postgres;

GRANT

Installing loader 'target-postgres'...
Installed loader 'target-postgres'

got through that time. so re-ran the above command and still got the pw authentication error. Please advise. Thanks!