Epps, Aaron M. writes:
> pg_hba.conf
> localallalltrust
> why when I run the following command does authentication fail (Yes, password is
> correct)?
You don't need a password in this setup.
> [EMAIL PROTECTED] aaron]$ psql test -U testing -W
> Password:
> psql: FATAL: IDENT authe
I solved my problems. I was issuing the wrong command to create users
and alter the user's passwords.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Sat, Sep 29, 2001 at 07:34:43PM -0700, Russ McBride wrote:
> I'm going to restate the situation since there was some confusion,
> judging from a couple of responses.
>
> The goal-- The goal is to be able to connect to my database from the
> very machine where the database sits, without worry
Russ-
You've got a real poser there... our system works fine with the same lines
in pg_hba. I think that means you may find your answer in the operating
system environment instead of the postgres setup.
> local all trust
> host all 127.0.0.1255.25
Graham Vickrage writes:
> host all 127.0.0.1 255.255.255.0ident sameuser
> host all 0.0.0.0 0.0.0.0 password
>
> I assumed that the above would solve my problem, which it only half manages.
> The local client connections are worki