I just posted the following question on Amazon’s forums:
I’m trying to build an Ansible playbook for provisioning Postgres databases on RDS, but ran into an issue while trying to create users. The playbook responds with the following:
psycopg2.ProgrammingError: permission denied **for** relation pg_authidFrom what I’ve researched, it appears Ansible’s postgres module tries to query pg_authid in order to compare passwords to make sure they match. Since pg_authid is shared across a cluster, is this catalog not available to the master user created for the RDS instance?
I was wondering if anyone here has seen the same issue and had any guidance or a workaround?