Re: pg_hba.conf problem?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Carlo Florendo <fcarlo(at)ntsp(dot)nec(dot)co(dot)jp>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_hba.conf problem?
Date: 2002-02-11 16:38:10
Message-ID: 20020211083648.G80839-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> This one below is part of my pg_hba.conf file:
>
> # This default configuration allows any local user to connect as any
> # PostgreSQL username, over either UNIX domain sockets or IP:
>
> host all 127.0.0.1 255.255.255.255 crypt
> host athena 172.28.61.13 255.255.255.255 trust amgarcia

> Basically, I want user "amgarcia" to authenticate before connecting to the database.
> If I change the "trust" to "crypt", the server asks for a password. It, however, does
> not want to accept the password "abc123".

Do you have a file amgarcia in your $PGDATA? AFAIK the last parameter is
not a username it's an external file containing users that are allowed to
authenticate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-02-11 16:56:22 Re: [HACKERS] Feature enhancement request : use of libgda in
Previous Message Tom Lane 2002-02-11 16:37:12 Re: initdb - segmentation fault