Hi,

I'm trying to create a schema with authorization parameter and it gives me following error:
ERROR: must be member of role "testrole"

Here is what I'm trying to do.

Create a user with create db and create role permissions:
CREATE ROLE system CREATEDB CREATEROLE LOGIN PASSWORD ‘system’

Create a DB using newly created user:
CREATE DATABASE dbtest OWNER system

Create a role in new database:
psql --host=x.x.x.x --port=xxxx --username=system dbtest --command="create role testrole with PASSWORD 'testrole '"

Now create a schema under a role name:
psql --host=x.x.x.x --port=xxxx --username=system dbtest --command="CREATE SCHEMA AUTHORIZATION testrole"

Then it gives me below error!
ERROR: must be member of role "testrole"

I'm new to postgres and I tried searching this but coudn't find any clue. Thanks in advance.