| From: | Ben Trewern <ben(dot)trewern(at)talktalk(dot)net> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | No password prompt logging into Postgres 8.4 |
| Date: | 2009-07-02 14:37:02 |
| Message-ID: | F55E240B-EA8F-485C-81A6-8CD19CD68CC0@talktalk.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)ben-desktop:~$ psql
Password:
psql (8.4.0)
Type "help" for help.
postgres=#
But if i do :
ben(at)ben-desktop:~$ psql -Upostgres
psql (8.4.0)
Type "help" for help.
postgres=#
You can also do :
ben(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hartman, Matthew | 2009-07-02 14:46:34 | Upgrading 8.3 to 8.4 on Windows. |
| Previous Message | Michaël Lemaire | 2009-07-02 14:27:31 | Re: Delete triggers order in delete cascade (pg 8.3.7). |