Re: createdb - Mailing list pgsql-general

From Alessio Bragadini
Subject Re: createdb
Date
Msg-id 3B5E746E.8AA75325@albourne.com
Whole thread Raw
In response to createdb  (Greg Donald <greg@destiney.com>)
List pgsql-general
Greg Donald wrote:

> Next, I wanted to create a new database name Test.  Do I do this as root,
> as my new user 'ralph', or as my regular unix username?

If your user ralph has database creation rights (it was asked when
creating the user) you can do
createdb -U ralph test

or some other db user (postgres) that has the rights to create a new db.

--
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"
        -- The Eighth Networking Truth from RFC 1925

pgsql-general by date:

Previous
From: Peter Peltonen
Date:
Subject: Re: 7.1.1: pgdump fails (SOLVED)
Next
From: newsreader@mediaone.net
Date:
Subject: Re: dumping trouble (solved)