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 cant
>> login as that user. I cant 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