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_authid > > > > From 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? -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/5aa0e5c2-83c2-4556-afa2-2d8eae3f89e1%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
