Re: PostGreSQL - Accessing It

In article <20030813043808(dot)A15117(at)laokoon(dot)bug(dot)net>, Thomas Beutin wrote:
>> I have the same problem as Michael. I've installed postgresql and am
>> running the service, but I can't log in as postgres. I just tried the
>> command line "psql -U postgres template1", but I get the message
>> "authentication failed for user 'postgres'". The administrator's manual
>> confirms that I first need to connect as this predefined user, but
>> doesn't say what that user's password is.
> Did You tried "su - postgres" as root? This should bring You into a
> shell of the postgres user.

Thanks for your response. Sorry for not getting back to you guys sooner
(I was away).

I've changed the password for postgres now and am able to successfully
get into psql as postgres. I'm now having problems adding myself as a
user. After reading the admininstrator's manual I connected as postgres
and did a CREATE USER add myself as a user. When I then try to connect
as myself ("mel"), psql tells me that I'm not set up as a user. I've
copied my session below for clarity. What am I doing wrong?

[mel(at)Cr168131-a mel]$ su postgres
Password:
bash-2.05b$ psql test
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=# CREATE USER mel CREATEDB
test-# \q
bash-2.05b$ exit
exit
[mel(at)Cr168131-a mel]$ psql test
psql: FATAL 1: user "mel" does not exist

--

Mel Roman
mel(at)melroman(dot)net