Re: Pg_dumpall problem[2]

Thank you very much for the reply.

I tried your suggestion, and my OS [RH7] must not support it, because that
setting would not allow any logins (local or TCP/IP). A telnet attempt
resulted in "missing or erroneous pg_hba.conf".

I know what I am trying to do is possible, because on postgresql 6.5 it
worked like a charm. Haven't been able to get it working since upgrading to
7.1.

Any other suggestions?
TIA!
-jim

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Thursday, February 06, 2003 3:23 PM
To: James Hall
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Pg_dumpall problem[2]

On Thu, Feb 06, 2003 at 10:04:49 -0600,
James Hall <James(dot)Hall(at)RadioShack(dot)com> wrote:
> Since there were no replies to this, I did some testing w/pg_hba.conf
> since I thought the problem might be there. I now have a question
> about pg_hba.conf.
>
> I need pg_hba.conf to allow local connections [via telnet for example]
> to the database without requesting a password, but to request a
> password for clients connecting via the web based front end. All
> clients are on the 172.X.X.X ip range.
>
> My current pg_hba.conf shows:
> Local all password
> Host all 172.0.0.0 255.255.255.255 password

If supported by your OS use:
local all ident sameuser