"ERROR: must be member of role" When creating schema in PostgreSQL

Question

I'm logged in with a superuser account and this is the process I'm doing:

1-> CREATE ROLE test WITH IN ROLE testroles PASSWORD 'testpasswd' 2-> CREATE SCHEMA AUTHORIZATION test 

The role is correctly created but I'm getting this error when trying to create the Schema:

ERROR:  must be member of role "test" 

Answer 1

I ran into this issue when using CREATE DATABASE on Amazon RDS. I think it's essentially the same as using CREATE SCHEMA.

When using Amazon RDS, the user issuing the CREATE DATABASE must be a member of the role that will be the owner of the database. In my case, the superuser account I'm using is called root, and I'm going to create a role o which is going to own a database d:

postgres=> CREATE ROLE o; CREATE ROLE  postgres=> CREATE DATABASE d OWNER = o; ERROR:  must be member of role "o"  postgres=> GRANT o TO root; GRANT ROLE  postgres=> CREATE DATABASE d OWNER = o; CREATE DATABASE