Re: PostGreSQL - Accessing It

In article <3F397B8E.8080307@commandprompt.com>, "Joshua D. Drake" wrote:
> Michael wrote:
>
>> I cannot access/create a database from root or any of the other
>> accounts I have setup for RH9. I noticed that there is a user setup
>> for postgres (I guess this part of the postgres install) but can’t
>> login as that user. I can’t even read or change the password. How do I
>> get at PostGreSql?
>>
> You need to be the user postgres. Try psql -U postgres template1 . You
> may also have to initdb the database.
>

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.

How can I find out the password for user postgres so that I can finally
begin working with this database?

TIA,

--

Mel Roman
mel@melroman.net