| From: | <ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca> |
|---|---|
| To: | pat knoob <pknoob(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: getting started |
| Date: | 2003-03-16 05:08:48 |
| Message-ID: | Pine.A41.3.95.1030315220652.34104C-100000@freenet.edmonton.ab.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sat, 15 Mar 2003, pat knoob wrote:
> I've just installed pgsql on debian woody.
> when I do "psql connect postgres"
>
> I get "psql: FATAL 1: IDENT authentication failed for
> user "postgres""
>
> this is my hba.conf:
>
> local all
> ident sameuser
> host all 127.0.0.1 255.0.0.0
> ident sameuser
> host all 0.0.0.0 0.0.0.0
> reject
>
> what do I need to do?
I'm guessing you are trying to connect as some user other
than "postgres". If you are running as "root", you
need to (temporarily) change your ID to "postgres" and
then try to "psql ...".
su postgres
psql ...
Gord
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Haines | 2003-03-17 02:43:11 | Postmaster.pid & Unix domain socket errors, OS X |
| Previous Message | pat knoob | 2003-03-16 05:01:24 | getting started |