Re: Problem with PostgreSQL 8.1.4 Install (using RPMs) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem with PostgreSQL 8.1.4 Install (using RPMs)
Date
Msg-id 4138.1156530889@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with PostgreSQL 8.1.4 Install (using RPMs)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 7.4 - data recovery
Next
From: Tom Lane
Date:
Subject: Re: 7.4 - data recovery