Postgres issues on Amazon RDS related to pg_authid

311 views
Skip to first unread message

Grant Means

unread,
Apr 30, 2014, 9:25:39 AM4/30/14
to ansible...@googlegroups.com
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?
Reply all
Reply to author
Forward
0 new messages