Re: getting started - Mailing list pgsql-novice

From
Subject Re: getting started
Date
Msg-id Pine.A41.3.95.1030315220652.34104C-100000@freenet.edmonton.ab.ca
Whole thread Raw
In response to getting started  (pat knoob <pknoob@yahoo.com>)
Responses 'UNIQUE'
List 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


pgsql-novice by date:

Previous
From: pat knoob
Date:
Subject: getting started
Next
From: Ben Clewett
Date:
Subject: 'UNIQUE'