Hi. I’m trying to run an ETL pipeline for an RDS f...
# troubleshooting
b
Hi. I’m trying to run an ETL pipeline for an RDS for Postrgres target (target-postgres), but I’m getting an error: 2022-05-11T000354.416272Z [info ] psycopg2.errors.InsufficientPrivilege: permission denied for database beh_test cmd_type=loader job_id=beh_test1 name=target-postgres run_id=42e076b8-1a4d-46f7-8272-9a63d903fc8d stdio=stderr The Postgres user/role I’m using is a member of the rds_superuser role. Is something else required? Is there something else I’m missing? (Fyi, it works when using a local Postgres target (i.e. target-postgres).
t
RDS has some AWS-imposed restrictions that local installs don't. Try running with
--log-level=debug
and see if that tells you what's actually failing; with that information you may be able to find a solution.
I have multiple pipelines feeding data into RDS Postgres so I can tell you it should work...
b
Operator error. I’d created the db with the wrong owner. It’s working now. Thanks for the response.