Horton

Re: getting started

ghaverla@freenet.edmonton.ab.ca

View thread View on postgr.es
From: <ghaverla@freenet.edmonton.ab.ca>
To: pat knoob <pknoob@yahoo.com>
Cc: pgsql-novice@postgresql.org
Date: 2003-03-16T05:08:48Z
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