From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Paulo J(dot) Matos" <pocm(at)rnl(dot)ist(dot)utl(dot)pt>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: User creation of DB |
Date: | 2002-01-14 21:28:24 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGCEBFEDAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Paulo-
There are two ways to accomplish this. When you create the user, you can
type: "create user pdestroy createdb". Or now that the user has already been
created, do this: "alter user pdestroy createdb" Look here for more info:
http://www.postgresql.org/idocs/index.php?sql-createuser.html
http://www.postgresql.org/idocs/index.php?sql-alteruser.html
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Paulo J. Matos
> Sent: Monday, January 14, 2002 12:29 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] User creation of DB
>
>
> 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!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | David A Dickson | 2002-01-14 21:54:43 | Re: SELECT help (fwd) |
Previous Message | Jan Wieck | 2002-01-14 20:55:39 | Re: gborg |