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@sss.pgh.pa.us]
Sent: Monday, April 01, 2002 10:46 AM
To: kent.rigby@att.net
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Errors creating my first database
kent.rigby@att.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