| From: | Kevin Murphy <murphy2(at)speakeasy(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Permission denied to create database |
| Date: | 2007-05-04 13:06:14 |
| Message-ID: | 463B2FC6.6050403@speakeasy.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
joe=> \db+
List of tablespaces
Name | Owner | Location | Access
privileges | Description
------------+----------+----------+----------------------------------------+-------------
pg_default | postgres | | {postgres=C/postgres,joe=C/postgres} |
pg_global | postgres |
| |
joe=> \l+
List of databases
Name | Owner | Encoding | Tablespace | Description
-----------+----------+----------+------------+---------------------------
...
template1 | postgres | UTF8 | pg_default | Default template database
For some reason, I haven't succeeded by reading the docs and googling.
Thanks for jarring my memory,
Kevin Murphy
PostgreSQL 8.2.4
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-05-04 13:15:01 | Re: Permission denied to create database |
| Previous Message | Michael Stone | 2007-05-04 12:45:39 | Re: Feature Request --- was: PostgreSQL Performance Tuning |