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.
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.