| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Kevin Murphy <murphy2(at)speakeasy(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Permission denied to create database |
| Date: | 2007-05-04 13:15:01 |
| Message-ID: | 463B31D5.8040308@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashish Karalkar | 2007-05-04 13:20:06 | Re: Permission denied to create database |
| Previous Message | Kevin Murphy | 2007-05-04 13:06:14 | Permission denied to create database |