User creation of DB

From: pocm(at)rnl(dot)ist(dot)utl(dot)pt (Paulo J(dot) Matos)
To: pgsql-general(at)postgresql(dot)org
Subject: User creation of DB
Date: 2002-01-14 17:28:54
Message-ID: 87zo3ghmeh.fsf@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've just installed Postgresql, I've created a db using user
postgres, but how can I give a user permissions to create one
too...
Since, when I do:
pdestroy(at)localhost:~$ createdb test
psql: FATAL 1: user "pdestroy" does not exist
createdb: database creation failed

Any ideas?

Best regards,

--
Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt
Instituto Superior Tecnico - Lisbon
Software & Computer Engineering - A.I.
- > http://www.rnl.ist.utl.pt/~pocm
---
Yes, God had a deadline...
So, He wrote it all in Lisp!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-01-14 17:34:41 Re: Anyway to know which users are connected to postgres?
Previous Message tomasz konefal 2002-01-14 17:22:29 mixed insert... ?