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
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.