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.comhttp://people.collaborativefusion.com/~wmoran/