pg_hda.conf

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_hda.conf
Date: 2003-11-21 18:08:51
Message-ID: 1069430667.25767.16.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Stark 2003-11-21 19:03:16 Re: Expressional Indexes
Previous Message Viaris hotmail 2003-11-21 15:47:10 Re: Help for construct Query