I need to connect to our AWS RDS PostgreSQL 9.5 instance so I can add the
citext extension to
pg_catalog schema so it is available to all schemas (PG prepends
pg_catalog to the beginning of the
search_path by default).
I'm easily able to do this on my local machine:
> sudo su - postgres > psql > \c mydatabase > CREATE EXTENSION IF NOT EXISTS citext SCHEMA pg_catalog; > \q > exit
If I login to the RDS using a direct connection as AWS docs show, I am given
permission denied for schema pg_catalog when I try to
psql --host=myrdsawshostname --port=5432 --username=myusername --password --dbname=mydatabase
This is the only way I know how to connect and I can only seem to connect as "myusername" not "postgres".
What am I doing wrong here?