Re: step 2..

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     127.0.0.1   255.255.255.255     ident sameuser
 > host    all     all     0.0.0.0     0.0.0.0             reject

Mine looks like this:

#TYPE   DBASE   USER    IP-ADDRESS      IP-MASK         METHOD
#----   -----   ----    ----------      -------         ------
local   all     all                                     trust
host    all     all     127.0.0.1       255.255.255.255 trust
host    fishdb  simon   192.168.130.0   255.255.255.0   md5
host    treedb  janet   192.168.130.0   255.255.255.0   md5
host    tigerdb marion  192.168.130.0   255.255.255.0   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.

Regards
   Oliver

--
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