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 [EMAIL PROTECTED] Beam me up, Scotty. There is no intelligent live down in Redmond. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings