X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1971A474E5C
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 22:32:52 -0500 (EST)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id 7765E474E44
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 22:32:51 -0500 (EST)
Received: (qmail 7596 invoked by uid 500); 12 Feb 2003 03:46:15 -0000
Date: Tue, 11 Feb 2003 21:46:15 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Wei Weng <wengwei@alumni.stevens-tech.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: What is wrong with this identification configuration?
Message-ID: <20030212034615.GA7558@wolff.to>
Mail-Followup-To: Wei Weng <wengwei@alumni.stevens-tech.edu>,
	pgsql-sql@postgresql.org
References: <Pine.LNX.4.44.0302111825580.4868-100000@localhost.localdomain>
	<20030212014524.GB5831@wolff.to>
	<001801c2d240$da1cb6d0$2f437242@PASCAL>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <001801c2d240$da1cb6d0$2f437242@PASCAL>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/233
X-Sequence-Number: 11631

On Tue, Feb 11, 2003 at 21:45:49 -0500,
  Wei Weng <wweng@kencast.com> wrote:
> <SNIP>
> > The format of the hba.conf file changed between 7.1 and 7.2. It looks like
> > you are using an old one. After the database field, there is now a user
> > field. To get the same effect as before, use 'all' for the user.
> I installed PostgreSQL rpm on a fresh installed Redhat 7.3. There is no
> PostgreSQL 7.1 previously installed so I don't think the pg_hba.conf I was
> editing is a left-over copy.
> 
> Specifically, which part of the configuration:
> 
> 
> is wrong and should be fixed accordingly?

I think you want:
local   all     all                                           trust
host    all     all   127.0.0.1       255.255.255.255         trust

It is possible I am wrong about when the format changed. I have been using
7.3 for a long time now. But the error message you got suggested that it
was looking for a match of connection method, database and user which is
what the newer version of the config file lists. Previously on;y connection
method and database were used.