pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?
Date: Tue, 11 Feb 2003 21:46:15 -0600
Message-ID: <20030212034615.GA7558@wolff.to> (raw)
In-Reply-To: <001801c2d240$da1cb6d0$2f437242@PASCAL>
References: <Pine.LNX.4.44.0302111825580.4868-100000@localhost.localdomain>
	<20030212014524.GB5831@wolff.to>
	<001801c2d240$da1cb6d0$2f437242@PASCAL>

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.



view thread (4+ messages)

Message-ID: <20030212034615.GA7558@wolff.to>
Permalink:  ../20030212034615.GA7558@wolff.to/
Also on:    postgresql.org/message-id/20030212034615.GA7558@wolff.to

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bruno@wolff.to, wengwei@alumni.stevens-tech.edu
  Subject: Re: What is wrong with this identification configuration?
  In-Reply-To: <20030212034615.GA7558@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox