Обсуждение: No password prompt logging into Postgres 8.4

Using th new postgresql 8.4.0 (compiled)
On Ubuntu 8.10

I did an initdb, added a password to the postgres user and  then
changed the pg_hba.conf to:

local   all   all      md5
host   all   all     127.0.0.1/32      md5

Restarted Postgresql.

If I log in normally:

postgres@ben-desktop:~$ psql
Password:
psql (8.4.0)
Type "help" for help.

postgres=#

But if i do :

ben@ben-desktop:~$ psql -Upostgres
psql (8.4.0)
Type "help" for help.

postgres=#

You can also do :

ben@ben-desktop:~$ psql -hlocalhost -Upostgres
psql (8.4.0)
Type "help" for help.

postgres=#

Note no password prompt either time!

Looks like a bug or am I not understanding this properly.

Ben

In response to Ben Trewern <ben.trewern@talktalk.net>:

> Using th new postgresql 8.4.0 (compiled)
> On Ubuntu 8.10
>
> I did an initdb, added a password to the postgres user and  then
> changed the pg_hba.conf to:
>
> local   all   all      md5
> host   all   all     127.0.0.1/32      md5
>
> Restarted Postgresql.
>
> If I log in normally:
>
> postgres@ben-desktop:~$ psql
> Password:
> psql (8.4.0)
> Type "help" for help.
>
> postgres=#
>
> But if i do :
>
> ben@ben-desktop:~$ psql -Upostgres
> psql (8.4.0)
> Type "help" for help.
>
> postgres=#
>
> You can also do :
>
> ben@ben-desktop:~$ psql -hlocalhost -Upostgres
> psql (8.4.0)
> Type "help" for help.
>
> postgres=#
>
> Note no password prompt either time!

Does user ben have a .pgpass file?

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/