[GENERAL] 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: 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! Looks like a bug or am I not understanding this properly. Ben -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] No password prompt logging into Postgres 8.4
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