https://linen.dev logo
#plugins-general
Title
# plugins-general
m

mindy_ng

02/19/2021, 5:49 PM
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:
Copy code
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;
Copy code
GRANT
Copy code
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!