Re: PostGreSQL - Accessing It

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
>
>