Re: Errors creating my first database

Hi,

There's an easy fix for this:

createdb -Upostgres (dbname)

or

createuser -Upostgres (new_user_name)

It will then pop up asking for the password for the postgres user.

The problem is you're running these commands as yourself, not as the
postgres 'super-user'.

Since postgres doesn't know anything about your user (yet), it can't verify
your access.

See how that goes.

>When I run createdb I get the following error:
>psql: FATAL 1: User "my_user_name" does not exist
>createdb: database creation failed
>
>When I run createuser I get the following error:
>pgsql: FATAL 1: user "my_user_name" does not exist
>createuser: creation of user "new_user_name" failed
>
>in both cases "my_user_name" is the name of the unpriviliged user account
>under which I am currently logged in. "newa_user_name" is the name of the
>user I am trying to create (which just happens to be my current login name.
>
>PS I tried to create a database using PgAccess and I got this error:
>Tcl error executing pg_exec create database "database_name"
>is not a valid postgresql connection.
>
>I hope this helps. I am going to Barnes and Nobles right now to look for
>the Practical PostgreSQL book that Ugly Hippo suggested.
>
>Kent
>
>-----Original Message-----
>From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>Sent: Monday, April 01, 2002 10:46 AM
>To: kent(dot)rigby(at)att(dot)net
>Cc: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] Errors creating my first database
>
>
>kent(dot)rigby(at)att(dot)net writes:
> > I have shut down my Linux box out
> > of frustration so I can't tell you all the exact error, sorry.
>
>We'll really need to see the exact commands you issued and the exact
>responses you got to be able to offer much constructive help.
>
>Cut-and-paste from a terminal window is a real good way to illustrate
>such problems...
>
> regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

-----------------
Chris Smith
http://www.squiz.net/