Skip site navigation (1) Skip section navigation (2)

Re: step 2..

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: tallison(at)tacocat(dot)net (Tom Allison)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: step 2..
Date: 2004-03-17 11:42:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Tom Allison wrote:
 > psql: FATAL:  IDENT authentication failed for user "foo"
 > pg_hba.conf?
 > I have entries like:
 > local   all     postgres                                ident sameuser
 > local   all     all                                     ident sameuser
 > host    all     all     ident sameuser
 > host    all     all             reject

Mine looks like this:

#----   -----   ----    ----------      -------         ------
local   all     all                                     trust
host    all     all trust
host    fishdb  simon   md5
host    treedb  janet   md5
host    tigerdb marion   md5
... etc.

 > I have the exact same user and password set in my login user files as 
 > what I created using the sql script above.

What do you mean by "login user files"?  Database user are
not the same as login users.  In fact, they _should_ not be
the same.

 > I'm still getting the IDENT error.
 > suggestions?

Not using "ident" authentication?  It's insecure anyway.


Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"Python tricks" is a tough one, cuz the language is so clean. E.g.,
C makes an art of confusing pointers with arrays and strings, which
leads to lotsa neat pointer tricks; APL mistakes everything for an
array, leading to neat one-liners; and Perl confuses everything
period, making each line a joyous adventure <wink>.
        -- Tim Peters


pgsql-novice by date

Next:From: Tom AllisonDate: 2004-03-17 12:14:11
Subject: books
Previous:From: Christian PöcherDate: 2004-03-17 10:13:58
Subject: Re: Removing "lost" locks

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group