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