logo       
Google Custom Search
    AddThis Social Bookmark Button

pg_hda.conf: msg#00166

Subject: pg_hda.conf
Hi ...

I have just converted (upgraded) to Oliver's postgresql 7.4 debian
package (and, thanks for a nice package), and the installation went ok
(execpt it did not migrate automiticly, as it usually do), but ..

I can't log onto the database using different user names than the
current unix user id.

Fx. if I am user "www-data" I can't logon to database "wiki" as user
"wiki", but this use to work !

I know the magic is performed in the pg_hba.conf file, and I have been
there adding this :

local   all   all                                  trust
host    all   all    127.0.0.1    255.255.255.255  trust

But I still get this "IDENT" error while loging onto the system, WHY ? 

It act like I had written "same user" and not "trust", but only while
using 7.4. And yes I have restarted postmaster after fixing the config
files :-)

I am running debian linux sarge, on a i386 platform, if that helps.

Looking forward to any hint that may help me solve this problem.

/BL


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>