Hello,
Is this the default install for RedHat? What is the contents of your
pg_hba.conf file?
Thomas Beutin wrote:
>On Wed, Aug 13, 2003 at 01:34:00AM +0000, Mel Roman 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.
>
>HTH,
>-tb
>
>