Re: [SL] problem: postgres IDENT

[Jonas S. <jo...@jo...>]

On Tue, 2 Apr 2002, Keld Jørn Simonsen wrote:

> When I try to create a new database, or connect to an existing one I get
> the follwing error message: FATAL 1: IDENT authentication failed for
> user "postgres"
>
> I can see the dbs when running psql as postgres. Could it be a firewall
> problem, or networking problem or some passwd problem?
>
> This is just after moving from postgres 7.1 to 7.2 under Mandrake 8.2
> and loading the databases.

"ident" authentication method is new in Postgres 7.2.

Debian hacked something together called "peer" authentication, and it was
adopted upstream with version 7.2. If Mandrake adopted the "peer" scheme
used in 7.1 in Debian you need to replace all instances of that word with
"ident" in /etc/postgresql/pg_hba.conf.

But it could be other things as well... :-I

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/