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@wolff.to]
Sent: Thursday, February 06, 2003 3:23 PM
To: James Hall
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem[2]


On Thu, Feb 06, 2003 at 10:04:49 -0600,
  James Hall <James.Hall@RadioShack.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