Re: password is no required, authentication is overridden

Are you sure you don't have a pgpass file, or the environment variable
PGPASSWORD set?

cheers

andrew

Thomas Bley wrote:

> Hi,
>
> I already tried to mail security(at)postgresql(dot)org but my message was
> stalled.
>
> Version: 8.1.4 (binary for win32)
> OS: Windows XP SP2
>
> I type: pg_dump -h localhost -U postgres database_name and there is no
> question for the password.
>
> I haven't made changes to pg_hba.conf. I'm logged in as user "admin",
> not "postgres", the password is not empty.
>
> my pg_hba.conf:
>
> # ...
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
>
> without the -h localhost, I get the same (complete) dump
> http://www.postgresql.org/docs/current/static/sql-createtable.html
>
> SHOW hba_file;
> gives me:
> d:/program files/postgreSQL/8.1/data/pg_hba.conf
> (I only have one file named pg_hba.conf on my computer.
>
> I tried again with "pg_dump -U postgres -W database_name" when I enter
> the right password it passes, with the wrong one it denies me, without
> the "-W" it lets me pass.
>
> thanks and bye,
> Thomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>