Re: Getting this error when I use createdb

You do not have a database user named alexandre so the system will not
allow you to create a database using a user who does not exist.

Either create the user or createdb using a different user hich you have
already entered into the system

Usage:
createdb [options] dbname [description]

Options:
-D, --location=PATH Alternative place to store the database
-T, --template=TEMPLATE Template database to copy
-E, --encoding=ENCODING Multibyte encoding for the database
-h, --host=HOSTNAME Database server host
-p, --port=PORT Database server port
-U, --username=USERNAME Username to connect as
-W, --password Prompt for password
-e, --echo Show the query being sent to the backend
-q, --quiet Don't write any messages

By default, a database with the same name as the current user is created.

Read the bottom line starting By default

If you need to change the user then use the -U parameter

HTH

Darren Ferguson

On Fri, 21 Jun 2002, Alexandre Sebrao wrote:

> I getting this error when I tried to create a database called cservice:
>
> [alexandre(at)localhost alexandre] createdb cservice
> psql: FATAL 1: SetUserId> user 'alexandre' is not in 'pg_shadow'
> createdb: database creating failed
>
> This pgsql is already insert on my Linux Mandrake 8.0
> What can I do to make it work... plz I need this help!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Darren Ferguson