Обсуждение: Problem with PostgreSQL 8.1.4 Install (using RPMs)

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.

Lane Van Ingen wrote:
> Does anyone know what the initial user/password should be? Thanks.

Probably postgres without a password but with ident authentication,
which means you must log in as the postgres user on your OS.  (That one
probably doesn't have a password either, so go through root.)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Peter Eisentraut <peter_e@gmx.net> writes:
> Lane Van Ingen wrote:
>> Does anyone know what the initial user/password should be? Thanks.

> Probably postgres without a password but with ident authentication,
> which means you must log in as the postgres user on your OS.  (That one
> probably doesn't have a password either, so go through root.)

ie, something like

    sudo su - postgres -c "psql"

Since the default is ident auth, even if you'd assigned a password it
would be irrelevant to whether you could get into the database or not.
If you want to use passwords to control that, you'll need to edit
pg_hba.conf.

            regards, tom lane