Re: Authentification

On Thu, 21 Jun 2001, Tom Lane wrote:

> > I´m using PostgreSQL 7.1.2 (from Debian). My pg_hba.conf looks like
>
> > # default
> > local all peer sameuser
>
> There is no such authentication type as "peer".
Hmm, seems to be a bug in the Debian package.
>From /etc/postgresql/pg_hba.conf:

# peer: Authentication is done as for ident, but by obtaining user
# identification from the Unix socket credentials. (This
# service is only supported by a few operating systems. If
# it is not usable in a particular implementation, use of
# this method will cause an error.) Username mapping is
# exactly the same as for ident.

BUT:
If I remove the above line I get

_pg.error: No pg_hba.conf entry for host localhost, user testuser, database test

conn = DB('test')

which worked *with* the line. The the peer authentication type "peer" seems
to exist in the way it is described in the pg_hba.conf comment and is
necessary for the socket authentification via ident.
The same message do I get when trying the crypt athentication as in my
original question.

So it seems the line is evident for my setup.

Kind regards

Andreas.