Re: No password prompt logging into Postgres 8.4 - Mailing list pgsql-general

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/