In response to Ben Trewern <ben.trew...@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: > > postg...@ben-desktop:~$ psql > Password: > psql (8.4.0) > Type "help" for help. > > postgres=# > > But if i do : > > b...@ben-desktop:~$ psql -Upostgres > psql (8.4.0) > Type "help" for help. > > postgres=# > > You can also do : > > b...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
