No password prompt logging into Postgres 8.4

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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).