| 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 |