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:
jdub
commented
5 years ago
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 DBcreate 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.ymlWhen 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