| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "Lane Van Ingen" <lvaningen(at)esncc(dot)com> |
| Subject: | Re: Problem with PostgreSQL 8.1.4 Install (using RPMs) |
| Date: | 2006-08-25 18:34:49 |
| Message-ID: | 4138.1156530889@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Peter Eisentraut <peter_e(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-25 18:36:31 | Re: 7.4 - data recovery |
| Previous Message | Peter Eisentraut | 2006-08-25 18:31:00 | Re: 7.4 - data recovery |