'ERROR: permission denied for relation pg_authid' when running against RDS

[claudio-santana-plangrid]

I created an empty DB in RDS using Postgres 9.6.6 owned by user postgres. I installed pgbedrock as a library (not as a container). Created an empty DB create database bedrock with encoding='UTF8' LD_COLLATE='en_US.UTF-8' LC_CTYPE='en_US.UTF-8' OWNER='postgres' ;. Ran the following command to generate the base spec:

pgbedrock generate \ -h MYINSTANCE.us-east-1.rds.amazonaws.com \ -p 5432 \ -d bedrock \ -U postgres \ -w <POSTGRES-PASSWORD> > spec.yml

When I look inside spec.yml it contains:

Failed to execute query " SELECT rolbypassrls, rolcanlogin, rolconnlimit, rolcreatedb, rolcreaterole, rolinherit, rolname, rolpassword, rolreplication, rolsuper, rolvaliduntil FROM pg_authid WHERE rolname != 'pg_signal_backend' ; ": permission denied for relation pg_authid

[jdub]

#47 is one approach to fix this, not yet merged.