Re: Permission denied to create database

Kevin Murphy wrote:
> Sleep deprived and surely doing something stupid here; I can't seem to
> confer the ability to create databases on a regular user.  I always get
> "permission denied to create database".  One note: template1 has had
> some C functions added to it.  Could that be related to the problem?
>
> $ createdb -U joe joejunkdb
> createdb: database creation failed: ERROR:  permission denied to create
> database
>
> $ 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

As a superuser: ALTER USER joe CREATEDB

Then go get some sleep :-)

--
   Richard Huxton
   Archonet Ltd