Re: pg_hda.conf

On Fri, 2003-11-21 at 18:08, Bo Lorentsen wrote:
> 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 ..

Automatic update is now controlled by a debconf question; the default
answer is no.

> 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

Please show all the uncommented lines.  Remember that the *first* match
is what governs.  If an  earlier "ident sameuser" line has matched, your
later additions will have no effect.

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

If the old pg_hba.conf was different, the resulting behaviour would
probably be different.  What changes were there between the old and the
new?  (If you had "ident sameuser" in 7.3 (or earlier) you would never
have been able to switch identities -- this has not changed between
versions.)

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "A new commandment I give unto you; That ye love one
      another. As I have loved you, so ye also must love one
      another.  By this shall all men know that ye are my
      disciples, if ye have love one to another."
                         John 13:34,35