# Postgres issues on Amazon RDS related to pg\_authid

**URL:** <https://forum.ansible.com/t/postgres-issues-on-amazon-rds-related-to-pg-authid/15118>\
**Category:** Ansible Project\
**Created:** [April 30, 2014, 1:25pm UTC](https://forum.ansible.com/t/postgres-issues-on-amazon-rds-related-to-pg-authid/15118 "2014-04-30T13:25:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant\_Means](https://avatars.discourse-cdn.com/v4/letter/g/e9a140/32.png) [@Grant\_Means](https://forum.ansible.com/u/Grant_Means)\
**Post date:** [April 30, 2014, 1:25pm UTC](https://forum.ansible.com/t/postgres-issues-on-amazon-rds-related-to-pg-authid/15118/1 "2014-04-30T13:25:39Z")

</div>

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:
> 
> ```auto
> 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?