Postgres Pro
Downloads
Home   >   mailing lists

Re: Permission denied to create database - Mailing list pgsql-general

From Mikko Partio
Subject Re: Permission denied to create database
Date
Msg-id 38822.2001:14b8:1b0:0:216:d4ff:fe03:2af0.1178293255.squirrel@haisuli.net
Whole thread Raw
In response to Permission denied to create database  (Kevin Murphy <murphy2@speakeasy.net>)
List pgsql-general
Tree view 
>
> $ sudo -u postgres psql -c "grant all on tablespace pg_default to joe"
> Password:
> GRANT
>
> $ createdb -U joe joejunkdb
> createdb: database creation failed: ERROR:  permission denied to create
> database
>

How about ALTER ROLE joe CREATEDB

Regards

MP

pgsql-general by date:

Previous
From: Thorsten Kraus
Date:
Subject: Re: Stored procedure
Next
From: "Hakan Kocaman"
Date:
Subject: Re: Stored procedure