Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: 42501: must be member of role "*" - Mailing list pgsql-admin

From marcos sr
Subject Re: ERROR: 42501: must be member of role "*"
Date
Msg-id CAEK-Xk0VJsRDyNV=Y1Lv-oG5_EX-yiC+CdQLBC=T5Og471zVRg@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: 42501: must be member of role "*"  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: ERROR: 42501: must be member of role "*"  (Pavan Teja <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view
Hello David thanks for attention,

CREATE USER "user" NOCREATEDB NOCREATEUSER NOINHERIT ENCRYPTED PASSWORD 'database'

CREATE DATABASE "database" WITH OWNER "user"


The user creating the db is not psql default.  Is a user who creates dbs on server and have the roles creatdb and create role. Can i give to this user a superuser privilege?


Sorry for the noob questions, but i'm new on postgres and have this thing to resolve. Is a legacy system on the company.

Sorry for the top-posting. now it's correct?

2018-02-06 16:13 GMT-02:00 David G. Johnston <david.g.johnston@gmail.com>:
On Tuesday, February 6, 2018, marcos sr <msr.mailing@gmail.com> wrote:
Hello

I'm new on postgres. I'm trying to create a database with a user who have CREATEDB role. But  I'm getting this error ERROR: 42501: must be member of role "name"


You need to provide the code that you are running, not just the resultant error message.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: ERROR: 42501: must be member of role "*"
Next
From: Pavan Teja
Date:
Subject: Re: ERROR: 42501: must be member of role "*"