Hi all, trying to surface data from the public-run...
# troubleshooting
m
Hi all, trying to surface data from the public-runs table to users and, as such, am trying to connect with tap-postgres (meltanolabs variant). I'm trying to connect to a postgres instance in Amazon RDS but am having trouble configuring the SSL connection correctly so it will connect. Does anyone have any experience with this or any suggestions, my Googling has come up with many variations of "turn off ssl on the server" which strikes me as a bad idea. The main error seems to be "no pg_hba.conf entry" for my server, but RDS has no way to modify that which I can find.
e
Are you able to connect to RDS with a straight Python (e.g. psycopg) client?
m
Yes, I've connected to the postgres db on the RDS server from the meltano server with the command line tools (psql).
I resolved this by changing from individual property specifications to just setting the config -> sqlalchemy_url string.
👍 1