Hi, i'm seeing a database connection error when i ...
# troubleshooting
k
Hi, i'm seeing a database connection error when i run
meltano --log-level=debug invoke dbt-postgres:run
, but I'm connecting fine with psql using the same credentials. I have 2 taps, Stripe and CSV, but only Stripe is in use for the transformation. Any ideas what's going on? Attaching part of the log in thread
a
Try running meltano config transformer dbt-postgres and see if the output helps.
k
Config output looks good to me. No role is configured, but I did try with a role & no change 😕
w
I think the default postgres port is 5432 and see you are using 5423
You may need to "sslmode: true" into the config?
k
that was it! port was wrong, Thank you!