The basic install of Red Hat (RHEL ES 4.0) for PostgreSQL version 8.1.4
appears to have gone well (database is up and running) except for one thing:
I can't login as postgres.
Assume the login would be 'postgres' or 'postgresql', but can't get in via
psql or pgAdmin3 to set up new users and database. I have looked through the
documentation, but don't see anywhere that tells what password I must use to
get in as the DBA.
Does anyone know what the initial user/password should be? Thanks.